I am sure I am missing a simple answer to my problem in creating a view in the latest 7.6 RBASE.
I use temp views all the time and have not had this problem before. The below syntax works fine on one table then does not work on another table. This works: create temporary view TEMP_TO (col names w/ commas ) as select partnum, sum(pieces), typeinv, location from INV_PART_LOC_UP + where clause w. group by clause. The sum(pieces) work fine and the view is created. Does not work create temporary view tOrdShiptots (col names w/ commas) as select Control#, Model#, Outshipinv, SortOne, Quantity, SUM(ShipQty) from OrderShip + where clause w. group by clause. The error I get on this view is -ERROR- Illegal column specification (2512) I know the culprit is the SUM(ShipQty) part since I can get a view with just the col name ShipQty. The ShipQty is a real data type so a sum function should work. It is used in only three tables and not a calculated field. Jim
