>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

This sounds familiar.

Thanx for the reply, I will give this a try (Today I hope, Network Problems).