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

Reply via email to