Since VFP doesn't have an auto-increment field,
how have others done their increment for web
applications?

I am using VFP tables and "ADO", we can't use any
locking schemes.

I don't want to use Access (too corruptable) or
SQL Server (extra cost by my web hosting service).
But those two databases do offer auto-increment.

I was thinking of using Application variables
but since every table has a primiary key,
there would be too many Application variables.

So once again ... how are you incrementing
your primary keys from VB Script to VFP tables?