Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writeable Cursors?
Message
From
17/12/1997 00:44:05
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00066144
Message ID:
00066457
Views:
39
>>>How do you make a SQL Cursor writeable ?
>> As others have told you the solution is:
>> SELECT * FROM MyTable INTO CURSOR Query
>> USE DBF("Query") IN 0 AGAIN ALIAS Writable
>>
>
>Also of note: Assuming that you want changes propagated through to a base table in a Client/Server application...there is a KB article that describes how to convert a result set (one returned via an SQL Pass-through query) into a read-write cursor such that changes will be propagated back to the base table on the server. It's basically done by using a bunch of cursorsetprop calls.

Hi Mark,

Would you know the title of this article?

Thanks,

Paul de Niverville
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform