get_next_generator_value
Advance a Firebird generator and return the next value for primary key assignment. Read current value by passing zero increment.
Instructions
Advance a generator (sequence) by the given increment and return the new value. Use this to obtain a primary key value before inserting a row that uses a generator-based ID. WARNING: this permanently advances the generator — the consumed value cannot be reclaimed. Returns {generator, increment, value}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database key from list_databases. | |
| generator | Yes | Generator name from list_generators. Automatically uppercased. | |
| increment | No | How much to advance the generator. Default 1 (get next ID). Pass 0 to read the current value without advancing. |