Dear All,

I am using VB6 with VFP9. I am connecting to VFP9 Database using ADO. In my table I have a field which increaments one number at every insert I make. Is there a way to get the AutoIncreament field value after I insert my record?

I don't want to use the Select Max(AutoIdentityField) here.

Can someone provide me a code example using VB with FoxPro9 table or VB with FoxPro9 stored procedure which can get me the AutoIncreament field value after every Insert.

Your help will be greatly appreciated.

Best Regards.