Information générale
Catégorie:
Codage, syntaxe et commandes
Hi All,
I'm having an uphill battle with a command that is macro substituted.
It's an UPDATE table SET var=1 command. I'm doing something like
lcWholeCommand = "UPDATE table SET var=1"
&lcWholeCommand
Now, the command is quite large and certainly exceeds 1000 characters. According to the help files this isn't a problem as VFP and handle commands that are 8192 characters long.
However, the macro substitution fails with a "commnad contains unrecognised phrase or keyword"
If, when my program has crashed I copy the lcWholeCommand to _CLIPTEXT and paste it into the command window, I get something really odd, Fox splits the command across two lines. If I execute the command with a semi colon between the two lines everything's ok.
BTW some of the var= parts of the command include memo fields which is why the command is so long.
Hope this makes sense.
Best wishes
Paul Robinshaw
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