>>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.html

Nice 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.