[Closed] Bug in TRIGGER

Discuss the database features
Post Reply
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

[Closed] Bug in TRIGGER

Post by dreamquartz »

Hi All,

As mentioned in the following topic: viewtopic.php?f=13&t=86906&start=30#p410938, I must conclude that there is indeed a bug in the TRIGGER process.
The moment a DataBAse is opened, does NOT mean that the TRIGGER is active.
I need to enter a wrong (=existing) CertificateCode first, before the TRIGGER is active. This does not make sense.
Is it not so that the "database.script" is read in its entirety, to build the database structure?

Hope someone can shed some light on this,

Dream
Last edited by dreamquartz on Wed Mar 29, 2017 2:06 am, edited 1 time in total.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
dreamquartz
Posts: 881
Joined: Mon May 30, 2011 4:02 am

Re: Bug in TRIGGER

Post by dreamquartz »

OK,

There is definitely more going on.
When closing and opening the database again, the TRIGGER is not active.

This might be caused by either the TRIGGER is incorrect, or it is a BUG.
I will consider it as the TRIGGER being incorrect for now, so I close this topic. and will re-open the above mentioned one.

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Post Reply