>Trying to debug code, came across a select statement that was missing a comma to separate fields like the following
>
>Select fld1, fld2, fld3 ;
> fld4, fld5 from cTable into cursor myCursor
>
>A cursor was created where values were selected from fld3 and column was labeled as fld4. Hence did cause considerable confusion.
>
>How long has the assumed 'AS' column name clause been working this way?
Ronald,
It should have generated a syntax error. Apparently, the AS clause in this case was being implied.
George
Ubi caritas et amor, deus ibi est