Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Select statement assumes 'AS' clause
Versions des environnements
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement