I trying to figure out how to generate a primary key for VFP tables being accessed via ODBC for ASP web pages.

I am familiar with the typical way to generate keys, using a table to hold key values, locking the record, incrementing the value, unlocking the record, and returning the incremented value. Unfortunately I don't see a way to do this via ODBC, where all I can use is SQL statements. I also don't see a way to call a VFP stored procedure via ODBC.

So... how do you do something like this?? IS there a way to call a VFP stored procedure via ODBC? If there is, how much of the language is available for use in that stored procedure? If not, how the heck do you do this?