Memory is hazy...

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

Thanks.