Page 1 of 1

TIBCConnection.Options.NoDBTriggers

Posted: Tue 06 Jun 2017 13:49
by Fabrice
Hello,

I have to copy a database (Firebird 2.5 or 3.0) from Charset "None" to another in Charset "UTF8".
I use Tibcquery and TCRBatchmove components.
It's work fine except for the option TIBCConnection.Options.NoDBTriggers:=true for my destination Database because I would like to disable all triggers of my destination database while executing Batchmove.

Does NoDBTriggers means :
1) "disable trigger for all the connection time" => it's doesn't work
2) "does not restore trigger" only when restore a database ?

If 2) Does it exist a method get list of all triggers like do GetTableNames or GetGeneratorNames ?


Best regards,
Fabrice

Re: TIBCConnection.Options.NoDBTriggers

Posted: Wed 07 Jun 2017 08:46
by ViktorV
The TIBCConnection.Options.NoDBTriggers property is responsible for disabling database triggers: https://firebirdsql.org/refdocs/langref ... igger.html
To disable the required triggers, you should refer to Firebird documentation or address this question to Firebird technical support.
To receive all database triggers, you can execute a query to the Firebird RDB $ TRIGGERS system table. For example:

Code: Select all

IBCQuery.SQL.Text: = 'select * from RDB $ TRIGGERS';
IBCQuery.Open;