Subject Re: [firebird-support] Re: Stored Proc Problem
Author Doug Chamberlin
At 9/21/2003 11:11 AM (Sunday), spencerr99 wrote:
>Nothing nearly that complicated. This very simple, I have done nothing
>other than the code I have sent you. All I do is call the generator
>one time to get the new value. Remember, this code has worked fine for
>months in Interbase, so it is not something I am doing.
>Again, if I run this code in IBOConsole (Firebird):
> select id from newrowid( 'person', 1);
>I get a return value of say, 79. When I run it again, immediately
>afterward, I get 81. The same thing occurs when running it though the
>Firebird JDBC Interbase driver.
>If I run the exact same code in IBConsole (Interbase) and the
>Interbase JDBC InterClient driver, it works correctly. The problem is
>clearly in the Firebird code.

Wait a second...let me double check what you are saying:

You are running first Firebird/IBOConsole/Jaybird combination and seeing an
increment of 2 in the generator. Then you stop Firebird and start
Interbase. You then run Interbase/IBConsole/Interclient combination and see
an increment of 1 in the generator? Is that right?

Finally, is this being done using the exact same database instance in each