From 8cbe4482ff93cc695079b2dbad8f21404372a891 Mon Sep 17 00:00:00 2001
From: prabatuty <prabatuty>
Date: Thu, 8 May 2008 10:02:01 +0000
Subject: [PATCH] setting the autocommit mode to off first before displaying
 the records

---
 src/tools/csqldump.cxx | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/src/tools/csqldump.cxx b/src/tools/csqldump.cxx
index 263aa290..68f7ac8c 100644
--- a/src/tools/csqldump.cxx
+++ b/src/tools/csqldump.cxx
@@ -107,7 +107,9 @@ int main(int argc, char **argv)
            }
             iter.reset();
             char sqlstring[1024];
+            bool flag=false;
             while (iter.hasElement()) {
+                 if (!flag) { printf("SET AUTOCOMMIT OFF;\n"); flag=true; } 
                  elem = (Identifier*) iter.nextElement();
                  sprintf(sqlstring, "SELECT * FROM %s;", elem->name);
                  sqlconn->beginTrans();
-- 
2.11.4.GIT