You may want to check new GETAUTOINCVALUE() finction in VFP9.

>
>With VFP9, what is the best way to get back the Identity column value after an insert? Right now I have the below which does not return the autonumber column:
>
>

>OleDbDataAdapter insAdapter = new OleDbDataAdapter(
>	"Select MyCol From MyTable Where 1=0" ,this._dataConn );
>OleDbCommandBuilder insBuilder = new OleDbCommandBuilder( insAdapter );
>int insOk = insAdapter.Update( myDataSet.Tables["MyTable"] ); //returns 1
>

>