Difference between revisions of "CURSYNCNUM()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(One intermediate revision by one user not shown)
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[SQL INSERT|INSERT]], [[Optimizing Indexes using SYNCNUM]], [[RECNO()]], [[SQL Pseudo Columns|PSEUDO COLUMNS]], [[SQL SELECT|SELECT]], [[SYNCNUM()]], [[SQL UPDATE|UPDATE]]
+
[[SQL INSERT|INSERT]], [[Optimizing Indexes using SYNCNUM]], [[SQL Pseudo Columns|PSEUDO COLUMNS]], [[RECNO()]], [[ROWNUM()]], [[SQL SELECT|SELECT]], [[SYNCNUM()]], [[SQL UPDATE|UPDATE]]
  
  

Latest revision as of 11:08, 5 July 2011

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, Optimizing Indexes using SYNCNUM, PSEUDO COLUMNS, RECNO(), ROWNUM(), SELECT, SYNCNUM(), UPDATE


Description

The CURSYNCNUM() function returns the current (last assigned) unique sequence number 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.


Example

OPEN DATABASE southwind
SELECT distinct cursyncnum() FROM example


Products

Recital, Recital Server