Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
TableUpdate on a CursorAdapter view
Versions des environnements
I have created an updateable cursor in a cursor adapter hitting a Fox database ("Native" ). The .Fill() command works and the view(?) is created. I have set AllowUpdates to .t. and left the .UpdateCmd empty. The cursor only has two tables ( table1 and table2 and both have a candidate key on an id column ). I have set the .KeyFieldList equal to both ids ( "id1, id2" - not qualified ). When I change an updateable column in the cursor and fire a TableUpdate() I get an error that says I have not set the KeyFieldList property for a specific table. I look at the object in memory and the property is set to both tables' id fields.
If I try to create the cursor and set the .KeyFieldList to a qualified table.fieldname for the keys the .Fill() gets an error and says the KeyFieldList is wrong, so it won't let me qualify the keys list.
In Fox 7 when you wanted to set a view KeyFieldList you set it by Viewname.idfieldname. This also does not work ( cursorname.idfieldname ).
Can someone tell me what I am doing wrong?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement