[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index]

Reference for unit 'SQLDB' (#fcl)

TSQLConnection.GetNextValue

Get next value for a sequence

Declaration

Source position: sqldb.pp line 290

public function TSQLConnection.GetNextValue(

const SequenceName: string;

IncrementBy: Integer = 1

):Int64; virtual;

`SequenceName`		Sequence name for which to return the next value.
`IncrementBy`		Amount to increment the current value of the sequence with.

The current value of the sequence, incremented by IncrementBy

GetNextValue returns the next value for the sequence SequenceName, incrementing the current value with IncrementBy (default 1).

Not all databases support sequences, in that case an SQL error will be raised.