Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Attaching a cursor to a CA
Message
From
20/05/2017 03:09:51
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01651181
Message ID:
01651255
Views:
48
>I didn't say it correctly; of course you can add new records to the CA cursor incrementally. I meant you cannot retrieve more records from the DB incrementally. Here is an example. You create a CA object and call the CursorFill() method to get records of customer "ABC". Then, you make some changes to these records (of customer "ABC"). Now, say you want to add to the CA cursor records of the customer "CBS", leaving all the records of customer "ABC" in the cursor and not yet sent to the DB (via TableUpdate()). So this is what the difficulty: how to retrieve into the existing CA cursor more records from the base DB table.

sqlexec(h, ca.selectcmd, "temp")
insert into (ca.alias) select * from temp
use in temp

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform