Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updatable cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00168313
Message ID:
00168503
Vues:
29
>Put the list in a single string, like this:
>
>=CursorSetProp("KeyFieldList", "mas_sqlkey,master")
>

Master is the name of the cursor. Do I need to list every index field name?
The error I am getting is "No key columns are specified for the update table 'master'. Use the KeyFieldList property of the cursor." I AM!

DLC


>>I am trying to change a cursor from SQL Server to be act like a remote view and I am getting an error on the keylist command.
>>
>>lnR = SQLEXEC(g_sql_h1,"select * from master order by mas_sqlkey", 'master')
>>
>>=CursorSetProp("Tables", "master", "master")
>>=CursorSetProp("KeyFieldList", "mas_sqlkey", "master")
>>=CursorSetProp("UpdateNameList", "mas_delet master.mas_delet")
>>=CursorSetProp("UpdatableFieldList", "mas_delet")
>>=CursorSetProp("SendUpdates", .T.)
>>
>>Any ideas?
DLC
"Use the Right Tool for the Job!"
davidandcynthia@email.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform