![Prev: IS [NOT] DISTINCT FROM](images/prev-or18.png "Prev: IS [NOT] DISTINCT FROM"){kind=small}
| Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Operators and predicates → NEXT VALUE FOR |
|
|
|
Find a more recent version at Firebird 5.0 Language Reference: NEXT VALUE FOR
Available in: DSQL, PSQL
Added in: 2.0
Description: Returns the next value in a sequence. SEQUENCE is the SQL-compliant term for what InterBase and Firebird have always called a generator. NEXT VALUE FOR is fully equivalent to GEN_ID(..., 1) and is the recommended syntax from Firebird 2.0 onward.
Syntax:
NEXT VALUE FORsequence-name
Example:
new.cust_id = next value for custseq;
NEXT VALUE FOR doesn't support increment values other than 1. If you absolutely need other step values, use the legacy GEN_ID function.
See also: CREATE SEQUENCE, GEN_ID()
|
| Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Operators and predicates → NEXT VALUE FOR |