Information générale
Titre:
ID refresh with cursor adapter
Versions des environnements
Hi There,
I have trouble to get the value of identity column back when I insert a new record through cursor adapter (CA). I know with VFP 9.0 CA class, you can specify ID key in the CA property called InsertCmdRefreshKeyList but I am not sure whether or not it is the right property I should use. I don't have problem with straight CA (without parameters) since the CursorRefresh method will get the ID for the new record back. But with parameter CA (say the parameter is on ID field), I could not figure out the way to get the new ID before I issue the CursorRefresh. The result is that I always get the last record I was working on back, not the new one I added.
Any help there?
Thanks.
Marvin
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