Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Creating an SQL statement from strings
HI!
I am creating an SQL statement from strings and I don't know why this Select statement is not working. Code is as follows:
* creates an SQL statement
cTempSQL = 'select wcdet.wcnumber from wcdet' + ;
' INNER JOIN wceff ON wcdet.wcnumber = wceff.wcnumber' + ;
' INNER JOIN wcfreq ON wcdet.wcnumber = wcfreq.wcnumber WHERE ' + ;
cTempeff + ' AND (' + cTempfreq + ')' + 'Group by wcdet.wcnumber' + ;
'INTO CURSOR c:\temp\result'
* Executes select statement
&cTempSQL
I thought about using EVAL or EVALUATE but when I used it last time I ran into major problem. Eval or Evaluate for some reason didn't get rid of some object references and forms were not closing. I am hesitating to use these commands. Please advice if there is a better way of doing this.
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