Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ID refresh with cursor adapter
Message
From
12/05/2005 14:39:29
 
 
To
25/04/2005 15:39:40
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000
Network:
Novell 5.x
Database:
MS SQL Server
Miscellaneous
Thread ID:
01008206
Message ID:
01013548
Views:
13
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
Map
View

Click here to load this message in the networking platform