Hi,

Try NOFILTER clause in SELECT statement which does not optimize the query and forces VFP to create temp table.

Bye
Jayesh

>Get away from VFP for a couple of months and I just start to forget things.
>
>I have a table and I select a subset of data out with a SQL statement into a cursor. I then try to Use the cursor again inorder to make it updatable but I get an error that table does not exists. What am I forgetting.
>
>USE trtime SHARED IN 0
>
>SELECT truid, truserid, trjob, trcost, trdate, trtime, ;
> trbillable, trweekend, treditby, treditstamp ;
> FROM trtime ;
> WHERE truseid = ofrmmain.edituser ;
> AND trweekend = ofrmmain.weekend ;
> ORDER by truid ;
> INTO CURSOR curtrtime
>
>IF _tally >0
> USE curtrtime ALIAS curTime SHARED IN 0 AGAIN
>ENDIF
>
>** The use produces the not a table error