Hi,

I am using VFP6.0 front end to the above SQL. I need to generate a unique character based number for one of the files. The unique key will end up being something like abc-0000000001, so can't use the SQL self generating unique id.

My problem is that in VFP tables, I lock the record in the datafile that contains the counter, save the field to a memvar then increment the counter field by 1 and unlock the record, but how do I do the same thing in an SQL data file.

I want to lock the SQL record, retrieve its current value, increment the field by 1 and then unlock the record.


Regards
Doug Johnston