Kevin,

Thanks for your help.

Could you point me to an example of using scope_identity? I have been trying the examples in the .net help particually the examples of getting the auto-number field from an Access table, but I am still unable to query a VFP table with scope_identity to get the auto-inc value of the record that was just inserted.

Do you know of any examples of retrieving the auto-inc field value from a VFP table from .net?

Thanks,

Jerry




>Just as a follow-up...if you want to wrap all this up in a stored procedure, there was a discussion about this a few months ago. Check out message #930339 from Bonnie Berent.
>
>If all you want to do is run a subsequent query, then the scope_identity should work.
>
>Kevin