Never mind. I was using parent CA class from VFP8. CA in VFP9 has those refresh properties that solved my problems.
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only