I'm connecting to VFP DBC from a .NET applicaiton using the OLEDB provider. When I do an insert into a table using an autoinc field, I need to get the autoinc value back. In SQL Server I could use the SCOPE_IDENTITY feature, but I'm not finding this capability in VFP...
What is the most reliable way to do this? Keep in mind that this is going to be in a multi-user environment so I want to make sure I get the value back from the insert I just did, not someone elses insert that may have happend right after mine.