>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
I wish I had VFP 9 in order to try this.
Does putting the ID field as the "InsertCmdRefreshKeyList" work?
How about the GETAUTOINCVALUE function?
- Andy Rice
San Diego, CA