Difference between revisions of "SYNCNUM()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) m (SYNCNUM moved to SYNCNUM()) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | ''Note: The SYNCNUM Pseudo Column has been replaced with the SYNCNUM() function.'' | ||
| + | |||
==Purpose== | ==Purpose== | ||
| − | + | Function to return the unique sequence number assigned to a row from the specified table | |
==Syntax== | ==Syntax== | ||
| − | SYNCNUM | + | SYNCNUM() |
| Line 12: | Line 14: | ||
==Description== | ==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. | |
| − | + | ||
| − | The SYNCNUM | + | |
| Line 21: | Line 21: | ||
// Display all overdue accounts with 15% commission in | // Display all overdue accounts with 15% commission in | ||
// Sorted "name" and "paid date" order with the unique row sequence number. | // Sorted "name" and "paid date" order with the unique row sequence number. | ||
| − | + | OPEN DATABASE southwind | |
| − | + | SELECT syncnum(), recno() FROM example | |
| − | + | ||
| − | + | ||
| − | + | ||
</code> | </code> | ||
| Line 33: | Line 30: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| − | [[Category: | + | [[Category:Functions]] |
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
