Information générale
Catégorie:
Codage, syntaxe et commandes
I needed to do a sql query and pick a column based on a variable. By trial and error I discovered the following worked.
select desc, co;
from lit;
where lit.afscme="X";
and lit.&vstate="X";
and eng="X";
and mbrpiece="X";
into cursor test
The use aof the & in front of the variable was pure luck.
Is there any place that describes the syntax for the use and assignment of vairables. It seems as if I am always running into this type of problem in using and declaring variables.
Thanks
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