Subject RE: [IBO] Absolute unique value/generator/SP problem
Author Kevin Stanton
Hi Helen,
The other is just the same thing but for other
generators - nothing exciting. I knew I could not rollback the generator
assignment and I never as of yet have decremented a generator. I'll look to
change my ways in the IBO app, but will keep the SP around as I am starting
to develop a web app against the same database.
Very much looking forward to your Firebird book!

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Tuesday, June 22, 2004 7:15 AM
Subject: RE: [IBO] Absolute unique value/generator/SP problem


At 06:51 AM 22/06/2004 -0700, you wrote:
>Thanks Paul, GeneratorLinks is a bit too automatic for me as the field
>initialized with a "temporary" order number (incase the user cancels the
>order, don't want to use up an order nbr).
>I didn't have a clue about the method qryOH.Gen_ID. This is great to
>and does make the code MUCH cleaner.
>(I'm sure I missing some other good things in TIB_Query).

You didn't show us the whole of your SP, either. It kind of tailed off
with "other

Were you under the impression that you could "roll back" the assignment of
a generator from a SP? Cos you can't: you can decrement the generator
cause horrible things to, errrm, duplicate values...?!?!?!

IBO's GenID() function does exactly what the bits of your SP that you
showed us do, except there is no need to check conditions, of course. So,
if your SP only does what you showed us, then you don't need it for your
IBO apps. OTOH, it might be needed by someone else writing an app in a
less Firebird-friendly dev environment than IBO - that would be the only
justification for keeping it.


IB Objects - direct, complete, custom connectivity to Firebird or
without the need for BDE, ODBC or any other layer.

___________________________________________________________________________ - your IBO community resource for Tech Info
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]