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?
Jim Munn, MCSD
Visual Data Solutions