Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Update?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00175778
Message ID:
00175815
Views:
37
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform