Bug TIBCScript?

christio · Post by **christio** » Mon 07 Jun 2010 13:08

Hello,

I´m using IBDAC 3.10.0.14 with Firebird 2.1.3.

Following script raises an error:

ALTER TRIGGER JOURNAL_ANZAHLUNG INACTIVE;
ALTER TRIGGER JOURNAL_BIU_FIX_ANGEBOT INACTIVE;

However following code with Delimiter = '/' is ok:

Code: Select all

ALTER TRIGGER JOURNAL_ANZAHLUNG INACTIVE
/
ALTER TRIGGER JOURNAL_BIU_FIX_ANGEBOT INACTIVE
/

christio · Post by **christio** » Tue 08 Jun 2010 08:28

No news?

Dimon · Post by **Dimon** » Tue 08 Jun 2010 08:46

The point is that some InterBase versions allow to execute such query. To solve the problem use the '/' delimiter.

christio · Post by **christio** » Tue 08 Jun 2010 08:58

What do you mean with that?

Setting triggers inactive is also legal in firebird.
The common way in every admin tool for a series of triggers is

alter trigger1 ... active / inactive;
alter trigger2 ... active / inactive;
alter trigger3 ... active / inactive;
...

Dimon · Post by **Dimon** » Tue 08 Jun 2010 09:53

When you are using the ';' delimiter, TIBCScript executes this script as one SQL statement. But with the the '/' delimiter, TIBCScript executes every ALTER TRIGGER statement as a separate query.

christio · Post by **christio** » Tue 08 Jun 2010 12:58

Maybe I miss something ...

The delimiter ';' is the default delimiter. So the script should be correctly separated.

Why is this valid?

Code: Select all

GRANT a_role TO user1;
GRANT a_role TO user2;

Dimon · Post by **Dimon** » Wed 09 Jun 2010 11:30

Ok, we have fixed this problem. This fix will be included in the next IBDAC build.

christio · Post by **christio** » Wed 09 Jun 2010 12:32

Thank you.

Do you know when the next build releases?

Dimon · Post by **Dimon** » Wed 09 Jun 2010 13:36

The next IBDAC build will be released by the end of the next week.