Information générale
Titre:
Error with Select SQL
Hi,
I'm stumped with this problem and I just can't seem to find the correct =
answer. I've got a Select Sql query in a program, very simple, to get at =
some data, the problem is the name of the table is kept in a property. =
VFP does the query, but insted of naming the table with the name =
contained in the property it comes out something like "W17" which is =
obviously not what I want.
I tried in a cursor but came up with the same problem.
In short it looks like this :
*- Temp rep
gcRepTmp =3D "C:\temp\Sylvatmp\"
*- Name o the table
This.cTableess =3D RIGHT(SYS(2015),8)
*- SQL
SELECT code_ecsy,;
pourc ;
FROM prele_essen;
ORDER BY 1;
where id_tsc =3D "RKL0TVP81" ;
into table (gcRepTmp+this.cTableEss)
Does anyone have a clue has to how to get around this ?
TIA
-Ben
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