Difference between revisions of "SYNCNUM()"

Revision as of 15:12, 4 July 2011

Note: The SYNCNUM Pseudo Column has been replaced with the SYNCNUM() function.

Purpose

Function to return the unique sequence number assigned to a row from the specified table

Syntax

SYNCNUM()

See Also

INSERT, Optimizing Indexes using SYNCNUM, PSEUDO COLUMNS, SELECT, UPDATE

Description

The SYNCNUM() function returns the unique sequence number assigned to a row from the specified table. 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.

Example

// Display all overdue accounts with 15% commission in
// Sorted "name" and "paid date" order with the unique row sequence number.
OPEN DATABASE southwind
SELECT syncnum(), recno() FROM example

Products

Recital, Recital Server