[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;

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: Jun 22 2020