SQL Server has a 'nifty' output clause, however, I can't figure out how to capture the return value when using SQLExec. If my sql command is of the form "insert into tablename (code) output inserted.PrimaryKeyName values ('XXX')" and I run it in SQL Server management Studio it returns the primary key value on the screen. However, if I run the same command with SQLExec it only returns a negative number if not successful and a positive number indicating the number of records affected if successful. In VFP code how do I capture the 'inserted.PrimaryKeyName value'? Thanks!
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!