Unit 'SQLDB' Package
[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] [#fcl]

TSQLConnection.GetNextValue

Get next value for a sequence.

Declaration

Source position: sqldb.pp line 292

public function TSQLConnection.GetNextValue(

  const SequenceName: string;

  IncrementBy: Integer = 1

):Int64; virtual;

Arguments

SequenceName

  

Sequence name for which to return the next value.

IncrementBy

  

Amount to increment the current value of the sequence with.

Function result

The current value of the sequence, incremented by IncrementBy.

Description

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

Errors

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

See also

TSQLConnection.GetSequenceNames

  

Return a list of sequence names.


Documentation generated on: Jul 24 2023