Subject | Re: [IBO] Generators as rows IDs |
---|---|
Author | Fernando Azevedo |
Post date | 2008-03-31T15:44:21Z |
Very useful indeed, thank you!
Daniel Rail wrote:
Daniel Rail wrote:
>
> Hi,
>
> At Sunday, March 30, 2008, 6:31 PM, Fernando Azevedo wrote:
>
> > I use IBO and Firebird in a simple Delphi book catalog program I
> > developed. The PKs consist in firebird generators, triggered to
> > increment before each insert, as usual.The problem with this method (not
> > for me, of course, but for a client of mine) is that when we insert and
> > do not commit, the ID (the table PK) is lost, and therefore not used in
> > the next insert. This really annoys my client, because I use the ID in
> > grids, and as search parameters.
> > So, what do you suggest me? Is it possible for IBO to increment the
> > value only after commit? How will that affect my program?
>
> Have you looked at the information provided in the technical
> information sheets on IB Objects website.
>
> Here's the direct link to something that you would find useful:
> http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries
> <http://www.ibobjects.com/TechInfo.html#ti_AuditableSeries>
>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Solutions Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/3/2008 12:32
>