SEQUENCE-NEXT — Increment the value of a database sequence.
Function
sequence-next name &key database => result
The name of the sequence as a string, symbol or SQL expression.
A database object which defaults to *default-database*.
An integer.
Increment and return the value of the sequence called name in database which defaults to *default-database*.
(sequence-last [foo]) => 3 (sequence-next [foo]) => 4 (sequence-next [foo]) => 5 (sequence-next [foo]) => 6
Modifies the value of the sequence name in database.
The current value stored in database sequence name.
*default-database*
Will signal an error of type sql-database-data-error if a sequence called name does not exist in database.
create-sequence |
drop-sequence |
list-sequences |
sequence-exists-p |
sequence-last |
set-sequence-position |
sequence-next is a CLSQL extension.