I would like to see a switch added to qli to stop it from running database triggers.
The following patch seems to do the trick: Index: dtr.h =================================================================== --- dtr.h (Revision 53685) +++ dtr.h (Arbeitskopie) @@ -507,6 +507,7 @@ EXTERN bool QLI_abort; EXTERN bool QLI_echo; EXTERN bool QLI_trace; +EXTERN bool QLI_nod; EXTERN USHORT QLI_count; #ifdef DEV_BUILD EXTERN bool QLI_explain; Index: meta.epp =================================================================== --- meta.epp (Revision 53685) +++ meta.epp (Arbeitskopie) @@ -1439,7 +1439,12 @@ if (length) { dpb.insertString(isc_dpb_password, q, length); } + if (QLI_nod) { + dpb.insertInt(isc_dpb_no_db_triggers, 1); + } + + #ifdef TRUSTED_AUTH if (QLI_trusted) { dpb.insertTag(isc_dpb_trusted_auth); Index: dtr.cpp =================================================================== --- dtr.cpp (Revision 53685) +++ dtr.cpp (Arbeitskopie) @@ -124,6 +124,7 @@ #ifdef TRUSTED_AUTH QLI_trusted = false; #endif + QLI_nod = false; QLI_lines = 60; QLI_name_columns = 0; QLI_prompt = QLI_prompt_string; @@ -169,6 +170,11 @@ sw_buffers = atoi(*argv++); break; + case 'D': + QLI_nod = true; + break; + + case 'F': // fetch password { if (argv >= arg_end || **argv == '-') mit freundlichen Grüßen Frank Schlottmann-Gödde -- "Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets." - J.K. Rowling ------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel