>>>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!