General information
Category:
Coding, syntax & commands
Title:
Select statement assumes 'AS' clause
Environment versions
Network:
Windows 2003 Server
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only