Function to return the unique sequence number assigned to a row from the specified table
SYNCNUM([<workarea | alias>])
The SYNCNUM() function returns the unique sequence number assigned to a row from the specified table. The SYNCNUM() function operates on the current workarea unless a numeric <workarea> or character <alias> is specified.
Each new row inserted into a table will be assigned a unique sequence number for that table. Even if the row is deleted later or if all the rows are deleted from the table, that number will not be issued again.
CURSYNCNUM() and SYNCNUM() both return the 8 digit hexadecimal sequence number as a character string.
OPEN DATABASE southwind SELECT syncnum(), recno() FROM example