Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable Cursor - how?
Message
 
To
24/09/1999 13:48:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00268624
Message ID:
00268634
Views:
19
>How would I create a cursor from a select statement, accessing a VFP table, and be able to update that cursor?
>
>TIA
>
>/Chris

First create the cursor as usual.

Then look at the help for CURSORSETPROP. You can pass several parameters, but the first parameter is the property of the cursor you want to set. You will need to set several properties including Tables (the tables you will be updating), UpdatableFieldList (the fields that you want to be able to update), KeyFieldList (which fields are key values so the update can find the right record to update), UpdateType, and WhereType. There may be some other options you want to set, but I think this is the core set. Basically it sets the same properties that you would set visually when you design a View.

Mike
Michael P. Antonovich, MCSD
Email: mike@micmin.com
MicMin Associates - Orlando, FL


Previous
Next
Reply
Map
View

Click here to load this message in the networking platform