Difference between revisions of "TABLESEQNO()"

Latest revision as of 10:01, 7 July 2022

Purpose

Function to apply a default SEQNO() in client/server Web Apps

Syntax

TABLESEQNO(cDatabase, cTable)

See Also

CURRSEQNO(), RECNO(), REPLACE(), SEQNO(), SET SEQNO, UNIQUEROWID(), ZAP

Description

The TABLESEQNO() function returns the next unique sequence number (SEQNO()) for the specified table in the specified database.

It can be used to apply a default SEQNO() in client/server Web Apps. If SEQNO() is used in a default value for a column then when the App is generated as a Web or Mobile App SEQNO() will automatically be translated to use tableSeqno().

Example

? tableSeqno('southwind','employees')
open database southwind
use employees
? seqno()