Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor Update?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00175778
Message ID:
00175815
Vues:
39
>>>It seems like someone told me how to make a cursor created with select sql updatable. There was also a tip in FoxAdvisor explaining how index the same cursor as well but I can't seem to find it. Can someone give me a quick review?
>>
>>The trick is to use "USE.. AGAIN" see message #173908
>
>Sorry, Where do I find messages by number?

USE DBF(cursorname) AGAIN IN 0 ALIAS newalias
SELECT newalias

This gives you the ability to change data IN THE CURSOR ONLY - it does not allow the underlying table to be changed. Also allows you to index the cursor more than once. If you just want to create an index on the cursor, you can do this - only once though. Try to create another index and it will throw a wobbly! Check out CURSORSETPROP() - this should make it updatable!
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform