Hi experts!

At the backend using MSSQL, I have set a field to be primary key that automatically increments its value by 1. Similary with AUTOINC integer type in native foxpro table.

I have one row at the frontend to send data to the backend using remote view, minus of course a data for the primary field key since SQL shall provide the value automatically once it reaches the backend.

After issuing TABLEUPDATE, How do I then retrieve the automatically generated value from the primary key field at the backend so I can display it on the FORM?

I remember time ago, this was one feature to be included in VFP 9.

Is there any other way?

Hope you can help.

TIA

Rene-PCSO