Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Cursor for Remote Data
Message
 
À
14/08/2005 10:13:56
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxWeb
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Divers
Thread ID:
01040779
Message ID:
01040885
Vues:
18
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform