Information générale
Catégorie:
Codage, syntaxe et commandes
>Hi Mandy,
> What errors are you getting? What is the content of the variables?
> Keep in mind that if you are instructing SQL to place a file in a non-existent subdirectory, SQL will fail--it will not automatically create the subdirectory. Your syntax looks fine and what you are trying to do should work. Your error is probably in the contents of your variables. I suggest halting the execution of the program just before the SQL Select statement and examining the contents of the variables. That will probably point you to the problem.
> Regards, Chaim
Hi Chaim,
The error I'm getting is "Command contains unrecognized phrase/keyword". Here's my Select statement exactly:
SELECT * FROM &y INTO TABLE c:\ird96\surveys\&x\&y WHERE acode=&x
y=SYSTEM (the name of one of my files), x=00640 (char string & code for one of my agencies), and I do have a c:\ird96\surveys\00640 directory before running the command.
Will my 'WHERE acode=&x' realize that &x is a character string, not a number?
I just tried doing the above but using the actual values (SYSTEM & 00640) in place of the variables and it works fine.
Any ideas?
Mandy
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