Information générale
Catégorie:
Codage, syntaxe et commandes
-I did not say SQL "required" aliases.
-I did not mention a concern about uniqueness.
-I clearly stated that I had been taught to always prefix table alias when accessing more than one table in a SQL-SELECT statement.
-I asked _Marc_ if it "helped."
>It would not have worked in the Command Window if the SQL required table aliases on the fields. Fox tells you right away when a field is not unique in a query.
My point exactly.
>What do you mean about 'no assurance' as to which table is open? If the tables are opened prior to the SQL, then Fox utilizes those; otherwise, it would search along your path settings to open the tables specified in the FROM clause.
Gee, thanks.
>I just had to respond because I've never seen a useful response from you...
Précédent
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