Page 1 of 1
Bug TIBCScript?
Posted: Mon 07 Jun 2010 13:08
by christio
Hello,
I´m using IBDAC 3.10.0.14 with Firebird 2.1.3.
Following script raises an error:
Code: Select all
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
/
Posted: Tue 08 Jun 2010 08:28
by christio
No news?
Posted: Tue 08 Jun 2010 08:46
by Dimon
The point is that some InterBase versions allow to execute such query. To solve the problem use the '/' delimiter.
Posted: Tue 08 Jun 2010 08:58
by christio
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;
...
Posted: Tue 08 Jun 2010 09:53
by Dimon
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.
Posted: Tue 08 Jun 2010 12:58
by christio
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;
Posted: Wed 09 Jun 2010 11:30
by Dimon
Ok, we have fixed this problem. This fix will be included in the next IBDAC build.
Posted: Wed 09 Jun 2010 12:32
by christio
Thank you.
Do you know when the next build releases?
Posted: Wed 09 Jun 2010 13:36
by Dimon
The next IBDAC build will be released by the end of the next week.