SYNCNUM()

From Recital Documentation Wiki
Revision as of 11:07, 5 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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([<workarea | alias>])


See Also

CURSYNCNUM(), INSERT, Optimizing Indexes using SYNCNUM, RECNO(), ROWNUM(), PSEUDO COLUMNS, SELECT, UPDATE


Description

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.


Example

OPEN DATABASE southwind
SELECT syncnum(), recno() FROM example


Products

Recital, Recital Server