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
TIBCConnection.Options.NoDBTriggers
Re: TIBCConnection.Options.NoDBTriggers
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:
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;