Hi Mark,

Below is details of database properties

Database header page information:

Version:                               WI-V2.5.4.26856 Firebird 2.5

                Flags                                      0

                Checksum                           12345

                Generation                         941170

                Page size                             4096

                ODS version                       11.2

                Oldest transaction           941159

                Oldest active                      941160

                Oldest snapshot                               941160

                Next transaction              941161

                Bumped transaction       1

                Sequence number          0

                Next attachment ID        56

                Implementation ID          26

                Shadow count                   0

                Page buffers                      0

                Next header page           0

                Database dialect               3

                Attributes                           force write

    Variable header data:

                Sweep interval:                20000

Allocated pages:               603479

*END*

On the affected table that is transaction table(‘trnTable’), I am using triggers to generate ID’s. Below I am pasting queries for generating the unique IDs

Trigger that calls generator is fired on insertion:

CREATE TRIGGER 'BI_ID' FOR ‘trnTable’

ACTIVE BEFORE

  INSERT

POSITION 0

AS

BEGIN

  IF (NEW._ID IS NULL) THEN

      NEW._ID = GEN_ID(_ID_GEN, 1);

END

Generator:

CREATE GENERATOR _ID_GEN;

SET GENERATOR _ID_GEN TO 16594028

Thank you.

With Regards,

Joje T. George