CURSYNCNUM()

From Lianjapedia
Revision as of 10:44, 15 February 2013 by Yvonne.milne (Talk | contribs)

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

Purpose

Function to return the current (last assigned) unique sequence number assigned to a row in the specified table

Syntax

CURSYNCNUM([<workarea | alias>])

See Also

INSERT, PSEUDO COLUMNS, RECNO(), ROWNUM(), SELECT, SYNCNUM(), UPDATE

Description

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

Example

OPEN DATABASE southwind
SELECT distinct cursyncnum() FROM example