Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Data to Cursor, Try to Use Again, get error.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00122266
Message ID:
00122294
Vues:
33
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform