Generators in DBExpress

Generators in DBExpress

Postby brakaman » Wed 26 Mar 2008 21:40

How work with the generators?

After the method ApplyUpdates, increases the number is not shown.....

And how use it Before., After...

But after closing and opening the conexion again shows. OK

Sorry for your time.

Regards.
brakaman
 
Posts: 9
Joined: Mon 19 Feb 2007 20:52
Location: Spain

Postby Plash » Thu 27 Mar 2008 10:36

Please specify whether a trigger is used to set field value from the generator. If so, you should call Refresh method of dataset after ApplyUpdates to get new values.

You can call Refresh method from AfterApplyUpdates event handler.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby brakaman » Thu 27 Mar 2008 14:24

Plash wrote:Please specify whether a trigger is used to set field value from the generator. If so, you should call Refresh method of dataset after ApplyUpdates to get new values.

You can call Refresh method from AfterApplyUpdates event handler.


Hi Plash thanks for your interest.

Here he generator code
Code: Select all
SET SQL DIALECT 3;

SET NAMES ISO8859_1;

CREATE GENERATOR GEN_BANCOS_ID;

SET TERM ^ ;


CREATE OR ALTER TRIGGER BANCOS_BI FOR BANCOS
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.CODBANCO IS NULL) THEN
    NEW.CODBANCO = GEN_ID(GEN_BANCOS_ID,1);
END
^


SET TERM ; ^


Work fine with IBX Components and not work in your Query Demo. and if after click button Applyupdates i pulse Refresh button the project crashes
brakaman
 
Posts: 9
Joined: Mon 19 Feb 2007 20:52
Location: Spain

Postby brakaman » Thu 27 Mar 2008 20:29

Thanks Plash the problem is fixed


After call "Refresh" method of Dataset, is incremented code and is show correctly.

By the way... the trial version what type of protection has?

I not see anything :twisted:
brakaman
 
Posts: 9
Joined: Mon 19 Feb 2007 20:52
Location: Spain

Postby Plash » Fri 28 Mar 2008 08:22

There is 30 days trial period. You cannot use the driver after the trial period has expired.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for InterBase & Firebird