Hi Benoit,

Starting on July 14, 2003 SYS(2015) returns digits instaed of charcaters in position 2-4. To avoid a problem, make sure that the name starts with letter or '_' or use all 10 characters returned by SYS(2015).

This.cTableess = "_" + RIGHT(SYS(2015),7)

See Re: ALIAS failing with variable Thread #809859 Message #810012 for more details.



>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