Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Cursor for Remote Data
Message
 
To
14/08/2005 10:13:56
General information
Forum:
Visual FoxPro
Category:
FoxWeb
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01040779
Message ID:
01040885
Views:
19
You didn't have UpdateNameList
something like
****** Your code
CURSORSETPROP("SendUpdates",.T., "mycursor")
cursorsetprop("BatchUpdateCount",1, "mycursor")
cursorsetprop("CompareMemo",.T., "mycursor")
cursorsetprop("FetchAsNeeded",.F., "mycursor")
cursorsetprop("FetchMemo",.T., "mycursor")
cursorsetprop("FetchSize",100, "mycursor")
cursorsetprop("MaxRecords",-1, "mycursor")
cursorsetprop("Prepared",.F., "mycursor")
CURSORSETPROP("KeyFieldList", "autoser","mycursor")
cursorsetprop("AllowSimultaneousFetch",.F., "mycursor")
cursorsetprop("UpdateType",1, "mycursor")
cursorsetprop("UseMemoSize",255, "mycursor")
cursorsetprop("Tables","labtest1", "mycursor")
cursorsetprop("UpdatableFieldList","req_det_id,test_name,autoser", "mycursor")
cursorsetprop("WhereType",3, "mycursor")

***** UpdateNameList
cursorsetprop("UpdateNameList","req_det_id labtest1.req_det_id, "+;
                               "test_name  labtest1.test_name, "+;
                               "autoser    labtest1.autoser", "mycursor")
Check FAQ #8153 How to make SQL Pass-Through cursor updatable for more info
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform