>SQL Server 2005.
>I have Integer Identifier column as primary key. Using CA class for Inserts & Updates.
>
>How do I get the new ID created in SQl Server in my VFP Cursor?
>
>The prob is similar to the VFP problem discussed in Thread #
1191628 and solved in Message #
1191764.
Check
Re: Auto Refresh Key fields after insert with CA Thread #
1100805 Message #
1101047There is also a nice article at
http://www.foxclub.ru/articles/index.php?id=46#CursorAdapter, but unfortunately, in Russian.
If it's not broken, fix it until it is.
My Blog