General information
Title:
Sybase SQLAnywhere & generating a unique number
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only