Subject Re: [IBO] Re: Generator Links at runtime
Author Helen Borrie (TeamIBO)
At 04:03 PM 06-07-02 +0000, you wrote:
>I went with the DSQL way (since I'm only doing the insert once),
>however, when it runs the GEN_ID line.. It comes back saying 'Unable
>to get generator value'.
>I'm sure this has been seen before... What might be causeing this?
>- Roger

Check whether the generator exists. If you created it using IBConsole, it
possibly has a case-sensitive identifier.

Alternatively, you may need to start your transaction. Before the business
starts, test for it with
with DSQL1 do
if not IB_Transaction.TransactionIsActive then

Don't forget to Commit when the task is finished.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at