Getting back the AutoIncrement value foxpro table

[Gandalf23]

Hello all,

I have an INSERT statement on a vfp8.0 database which uses AutoIncrement. Somehow I want to retrieve the number that has been appended. In Sqlserver there is a IDENTITY that can do this but is there something for foxpro database?

 

[RiverGuy]

You would probably have to post this in the FoxPro forum. It seems as though you already know how to do this on the C# end?

 

[Gandalf23]

Probably, but I'm afraid that they would say:

You would probably have to post this in the C# forum as it has to do with C# programming.;-)

 

[RiverGuy]

Not really. I wouldn't expect to get advice on how to return the identity of a SQL Server Record in this forum over the SQL Server forum. It really is a FoxPro issue because all you're going to want is the syntax to pass to the FoxPro source from your program.

And also, most people in here use SQL Server, Access and Oracle as their database source in .Net in this particular forum I've notice.