Subject | Re: [IBO] Create and Change Generator value |
---|---|
Author | Lucas Franzen |
Post date | 2003-02-17T21:55:08Z |
"jubassauro " schrieb:
Link it to your IB_Connection (and a IB_Transsaction if you won't let it
AutoCommit) and add the appropriate SQL-statements to it, like:
CREATE GENERATOR NEWGEN;
SET GENERATOR NEWGEN TO 42;
then execute this script.
By the way:
Every TIB_Connection ans TIB_Statement has a function: GEN_ID (
<GENERATOR_NAME>, <INCREMENT> )
You can use it to alter a generator value, by applying the needed
increment value.
HtH
Luc.
>The simplest way should be using a TIB_Script.
> How to create a value of a generator and to alter its value in RUN-
> TIME just using IBO?
Link it to your IB_Connection (and a IB_Transsaction if you won't let it
AutoCommit) and add the appropriate SQL-statements to it, like:
CREATE GENERATOR NEWGEN;
SET GENERATOR NEWGEN TO 42;
then execute this script.
By the way:
Every TIB_Connection ans TIB_Statement has a function: GEN_ID (
<GENERATOR_NAME>, <INCREMENT> )
You can use it to alter a generator value, by applying the needed
increment value.
HtH
Luc.