> I want to insert from a text file an amount of data in my database. The

problem is that I need to deactivate the triggers in some tables for doing
that. I would like to deactivate the triggers in that tables for a while. Is
it there a sentence that lets me do this.

>

Yes, you can deactivate triggers. Do note that the triggers
will be deactivated for ALL connections, not just yours.

The command is:

ALTER TRIGGER trigger_name INACTIVE

and

ALTER TRIGGER trigger_name ACTIVE

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com