Subject | Re: [IBO] Does fetch auto inc. field in insert |
---|---|
Author | Andreas Pohl |
Post date | 2001-08-05T18:59:40Z |
Marcel,
try to set TIB_Query.GeneratorLinks( e.g. nr=gen_nr). So IBO will increase
generator value. Be aware to test of existence of "generated" PK values in
triggers (e.g. if (new.nr is null) then new.nr=Gen_id(gen_nr,1);). If not so
your PK will increased double. Set
TIB_Query.BufferSynchroFlag:=[bsBeforeEdit,bsAfterEdit,bsAfterInsert] so
your inserted row is visible instantly.
Mit freundlichem Gruss & Best Regards
Andreas Pohl
apohl@...
www.ibp-consult.com
try to set TIB_Query.GeneratorLinks( e.g. nr=gen_nr). So IBO will increase
generator value. Be aware to test of existence of "generated" PK values in
triggers (e.g. if (new.nr is null) then new.nr=Gen_id(gen_nr,1);). If not so
your PK will increased double. Set
TIB_Query.BufferSynchroFlag:=[bsBeforeEdit,bsAfterEdit,bsAfterInsert] so
your inserted row is visible instantly.
Mit freundlichem Gruss & Best Regards
Andreas Pohl
apohl@...
www.ibp-consult.com
----- Original Message -----
From: "Marcel" <ibobjects@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, August 05, 2001 7:48 PM
Subject: [IBO] Does fetch auto inc. field in insert
> [D5Ent, IBO_4_2_D]
>
> I use triger+generator to generate serial no. for primary key field. After
> insert, the grid dosn't up the auto inc. field value. This prevent me from
> edit the record immediately.
>
> /marcel
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>