Name

SEQUENCE-NEXT — Increment the value of a database sequence.Function

Syntax

      sequence-next name &key database => result

Arguments and Values

name

The name of the sequence as a string, symbol or SQL expression.

database

A database object which defaults to *default-database*.

result

An integer.

Description

Increment and return the value of the sequence called name in database which defaults to *default-database*.

Examples

(sequence-last [foo])
=> 3
(sequence-next [foo])
=> 4
(sequence-next [foo])
=> 5
(sequence-next [foo])
=> 6
      

Side Effects

Modifies the value of the sequence name in database.

Affected by

The current value stored in database sequence name.

*default-database*

Exceptional Situations

Will signal an error of type sql-database-data-error if a sequence called name does not exist in database.

See Also

create-sequence
drop-sequence
list-sequences
sequence-exists-p
sequence-last
set-sequence-position

Notes

sequence-next is a CLSQL extension.