>>If I'm inserting into a VFP8 table that has an autoinc integer field, and I'm inserting from an external program that using the VFP OLE DB Provider, is there anyway to retrieve the key that was generated from the insert?
>>
>>(Basically, I'm looking for an equivalent of SELECT Scope_Identity() that's in SQL Server.
>>
>>Thanks,
>>Kevin
>
>Did you tried GETAUTOINCVALUE(). This is VFP 9 function and I am not sure if it will works with OLEDB (Because it is not in HELP for supported commands and functions for OLEDB provider).
That's an old question, Borislav, and apparently for VFP8. Since I faced the same problem, I decided to get one more answer this way <g>
If it's not broken, fix it until it is.
My Blog