Return from Sql to VFP?

[rabbit75]

I hope this question was not posed before, I looked but didn't see anything like it.

I have a app using SQL Server 2000 for the database and VFP. There is a field, transaction, which is an identity field in SQL. Is there any way in VFP, when after inserting a new record (using sqlprepare, etc. and a stored procedure) to return that transaction number to VFP from SQL?

Hope this is clear.

Thanks

 

[danceman]

NO, you need to run another SQL to the server to retrive it. SQLexecute has no way of returning info othere then error or success operation. Now, if you are calling a stored procedure to do this insert, why not modify the stored procedure to write some sort of data out to a specific location that you could check on. Attitude is Everything

 

[rabbit75]

Thanks

Found this to use too: SELECT IDENT_CURRENT(table)
which returns the identity (transaction number) of the record just added. Added it to the end of the stored procedure and the cursor is returned to vfp.

 

[danceman]

IDENT_CURRENT, is this a SQL Server 2000 property, stored procedure? Attitude is Everything

 

[rabbit75]

IDENT_CURRENT is a SQL SERVER property.