General information
Category:
Coding, syntax & commands
>How can I generate a id automatically for each record.
Concept is to have a table (I have named it "tables") that stores each of your table name and also the next available unique id for the table. When you need an id, find the record in "tables", lock the record, get the id, increment it, then unlock the table.
An example can be found in the Tastrade example that ships with VFP. In particular the function is newid().
Previous
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