>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!

What is your PK?
Some IDENTITY column?
If so use this:

TEXT TO lcInsert NOSHOW TEXTMERGE
     INSERT INTO TableName (Code) VALUES(?lcCode)
     SELECT SCOPE_IDENTITY() AS NewPK
ENDTEXT
IF SQLEXEC(lnSQLHandler, lcInsert, "crsNewPk") < 0
   AERROR(laError)
   MessageBox(laError[1,2])
   RETURN
ENDIF
WAIT WINDOW "New PK values is "+TRANSFORM(crsNewPk.NewPk)

or use Stored Procedure or use CursorAdapter :-)