>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
TRY USE DBF('curtrtime') IN 0 AGAIN ALIAS thisone SHARED
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com