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