>>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.
>
>Found this article
http://sqlservercode.blogspot.com/2006/10/hello-output-see-you-later-trigger-or.htmlNice to have feature, but the CA won't use the Output from the Output clause anywhere.
The equivalent to
InsertCmdRefreshCmd = "SELECT Id FROM Table1 WHERE Id = GETAUTOINCVALUE(0)"
to a CA connected to SQL Server 2000 or higher should be
InsertCmdRefreshCmd = "SELECT Id FROM Table1 WHERE Id = IDENT_CURRENT('Table1')"
Bye, Olaf.