test/sqlapi/Csql/DMLStmt/updrelationalonalldatatype.c

   1 /*
   2   Test Update conditionally using relational operators on all datatypes.
   3   CREATE TABLE t1(f1 TINYINT,f2 SMALLINT,f3 INT,f4 BIGINT,f5 CHAR(20),f6 VARCHAR(30),f7 FLOAT,f8 DOUBLE,f9 DATE,f10 TIME,f11 TIMESTAMP);
   4   Insert 5 records into t1.
   5   INSERT INTO t1 VALUES(1,11,111,1111,'CSQL1','LAKSHYA1',11.00,1111.00,'2001-01-01','01:01:01','2001-01-01 01:01:01');
   6   INSERT INTO t1 VALUES(2,22,222,2222,'CSQL2','LAKSHYA2',22.00,2222.00,'2002-02-02','02:02:02','2002-02-02 02:02:02');
   7   INSERT INTO t1 VALUES(3,33,333,3333,'CSQL3','LAKSHYA3',33.00,3333.00,'2003-03-03','03:03:03','2003-03-03 03:03:03');
   8   INSERT INTO t1 VALUES(4,44,444,4444,'CSQL4','LAKSHYA4',44.00,4444.00,'2004-04-04','04:04:04','2004-04-04 04:04:04');
   9   INSERT INTO t1 VALUES(5,55,555,5555,'CSQL5','LAKSHYA5',55.00,5555.00,'2005-05-05','05:05:05','2005-05-05 05:05:05');
  10   INSERT INTO t1 VALUES(6,66,666,6666,'CSQL6','LAKSHYA6',66.00,6666.00,'2006-06-06','06:06:06','2006-06-06 06:06:06');
  11   INSERT INTO t1 VALUES(7,77,777,7777,'CSQL7','LAKSHYA7',77.00,7777.00,'2007-07-07','07:07:07','2007-07-07 07:07:07');
  12   INSERT INTO t1 VALUES(8,88,888,8888,'CSQL8','LAKSHYA8',88.00,8888.00,'2008-08-08','08:08:08','2008-08-08 08:08:08');
  13   INSERT INTO t1 VALUES(9,99,999,9999,'CSQL9','LAKSHYA9',99.00,9999.00,'2009-09-09','09:09:09','2009-09-09 09:09:09');
  14
  15   UPDATE t1 SET f1=10, f2=100, f3=1000, f4=10000, f5='CSQLMMDB', f6='LAKSHYA_BANGALORE', f7=100, f8=10000,f9='2009-01-10', f10='01:01:10', f11='2009-01-10 01:01:10' WHERE f1=1;
  16   UPDATE t1 SET f1=20, f2=200, f3=2000, f4=20000, f5='CSQLMMDB2', f6='LAKSHYA_BANGALORE2', f7=200, f8=20000,f9='2009-01-11', f10='01:01:11', f11='2009-01-11 01:01:11' WHERE f2=100;
  17   UPDATE t1 SET f1=30, f2=300, f3=3000, f4=30000, f5='CSQLMMDB3', f6='LAKSHYA_BANGALORE3', f7=300, f8=30000,f9='2009-01-12', f10='01:01:12', f11='2009-01-12 01:01:12' WHERE f3=2000;
  18   UPDATE t1 SET f1=40, f2=400, f3=4000, f4=40000, f5='CSQLMMDB4', f6='LAKSHYA_BANGALORE4', f7=400, f8=40000,f9='2009-01-13', f10='01:01:13', f11='2009-01-13 01:01:13' WHERE f4=30000;
  19   UPDATE t1 SET f1=50, f2=500, f3=5000, f4=50000, f5='CSQLMMDB5', f6='LAKSHYA_BANGALORE5', f7=500, f8=50000,f9='2009-01-14', f10='01:01:14', f11='2009-01-14 01:01:14' WHERE f5='CSQLMMDB4';
  20   UPDATE t1 SET f1=60, f2=600, f3=6000, f4=60000, f5='CSQLMMDB6', f6='LAKSHYA_BANGALORE6', f7=600, f8=60000,f9='2009-01-16', f10='01:01:16', f11='2009-01-16 01:01:16' WHERE f6='LAKSHYA_BANGALORE5';
  21   UPDATE t1 SET f1=70, f2=700, f3=7000, f4=70000, f5='CSQLMMDB7', f6='LAKSHYA_BANGALORE7', f7=700, f8=70000,f9='2009-01-17', f10='01:01:17', f11='2009-01-17 01:01:17' WHERE f7=600;
  22   UPDATE t1 SET f1=80, f2=800, f3=8000, f4=80000, f5='CSQLMMDB8', f6='LAKSHYA_BANGALORE8', f7=800, f8=80000,f9='2009-01-18', f10='01:01:18', f11='2009-01-18 01:01:18' WHERE f8=70000;
  23   UPDATE t1 SET f1=90, f2=900, f3=9000, f4=90000, f5='CSQLMMDB9', f6='LAKSHYA_BANGALORE9', f7=900, f8=90000,f9='2009-01-19', f10='01:01:19', f11='2009-01-19 01:01:19' WHERE f9='2009-01-18';
  24   UPDATE t1 SET f1=100, f2=1000, f3=10000, f4=100000, f5='CSQLMMDB10', f6='LAKSHYA_BANGALORE10', f7=1000, f8=100000,f9='2009-01-20', f10='01:01:20', f11='2009-01-20 01:01:20' WHERE f10='01:01:19';
  25   UPDATE t1 SET f1=110, f2=1100, f3=11000, f4=110000, f5='CSQLMMDB11', f6='LAKSHYA_BANGALORE11', f7=1100, f8=110000,f9='2009-09-09', f10='09:09:09', f11='2009-09-09 09:09:09' WHERE f11='2009-01-20 01:01:20';
  26
  27   UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f1<3;
  28   UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f2<3;
  29   UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f3<3;
  30   UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f4<3;
  31   UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f5<'CSQL3';
  32   UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f6<'LAKSHYA3';
  33   UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f7<3;
  34   UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f8<3;
  35   UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f9<'2003/03/03';
  36   UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f10<'03:03:03';
  37   UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f11<'2003/03/03 03:03:03';
  38
  39   UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f1<=4;
  40   UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f2<=4;
  41   UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f3<=4;
  42   UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f4<=4;
  43   UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f5<='CSQL4';
  44   UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f6<='LAKSHYA4';
  45   UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f7<=4;
  46   UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f8<=4;
  47   UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f9<='2004-04-04';
  48   UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f10<='04:04:04';
  49   UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f11<='2004-04-04 04:04:04';
  50
  51   UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f1!=7;
  52   UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f2!=77;
  53   UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f3!=777;
  54   UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f4!=7777;
  55   UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f5!='CSQL7';
  56   UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f6!='LAKSHYA7';
  57   UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f7!=77.000000;
  58   UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f8!=7777.000000;
  59   UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f9!='2007/7/7';
  60   UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f10!='07:07:07';
  61   UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f11!='2007/07/07 07:07:07';
  62   SELECT * FROM t1;
  63 */
  64 #include"common.h"
  65
  66 int main()
  67 {
  68     DbRetVal rv = OK;
  69     AbsSqlConnection *con = createConnection();
  70     rv = con->connect("root","manager");
  71     if(rv !=OK) {
  72         delete con;
  73         return 1;
  74     }
  75     printf("Connection opened\n");
  76     AbsSqlStatement *stmt = createStatement();
  77     stmt->setConnection(con);
  78 //Creating Table
  79     char statement[400];
  80     printf("CREATE TABLE t1(f1 TINYINT,f2 SMALLINT,f3 INT,f4 BIGINT,f5 CHAR(20),f6 VARCHAR(30),f7 FLOAT,f8 DOUBLE,f9 DATE,f10 TIME,f11 TIMESTAMP);\n");
  81     strcpy(statement,"CREATE TABLE t1(f1 TINYINT,f2 SMALLINT,f3 INT,f4 BIGINT,f5 CHAR(20),f6 VARCHAR(30),f7 FLOAT,f8 DOUBLE,f9 DATE,f10 TIME,f11 TIMESTAMP);");
  82     int rows=0;
  83     rv = stmt->prepare(statement);
  84     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 2; }
  85     rv = stmt->execute(rows);
  86     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 3; }
  87     stmt->free();
  88 // Show all tables
  89     strcpy(statement,"GETALLTABLES;");
  90     rows=0;
  91     rv = stmt->prepare(statement);
  92     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 4; }
  93     stmt->execute(rows);
  94     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 5; }
  95     while(stmt->next() !=NULL) {
  96         printf("Table Name is %s\n",stmt->getFieldValuePtr(2));  //stmt->getFieldValuePtr(2) returns the TABLE_NAME (src/sql/SqlStatement.cxx)
  97     }
  98     stmt->free();
  99
 100 //Inserting Records
 101     con->beginTrans();
 102     rows=0;
 103     stmt->prepare("INSERT INTO t1 VALUES(1,11,111,1111,'CSQL1','LAKSHYA1',11.00,1111.00,'2001-01-01','01:01:01','2001-01-01 01:01:01');");
 104     stmt->execute(rows);
 105     rows=0;
 106     stmt->prepare("INSERT INTO t1 VALUES(2,22,222,2222,'CSQL2','LAKSHYA2',22.00,2222.00,'2002-02-02','02:02:02','2002-02-02 02:02:02');");
 107     stmt->execute(rows);
 108     rows=0;
 109     stmt->prepare("INSERT INTO t1 VALUES(3,33,333,3333,'CSQL3','LAKSHYA3',33.00,3333.00,'2003-03-03','03:03:03','2003-03-03 03:03:03');");
 110     stmt->execute(rows);
 111     rows=0;
 112     stmt->prepare("INSERT INTO t1 VALUES(4,44,444,4444,'CSQL4','LAKSHYA4',44.00,4444.00,'2004-04-04','04:04:04','2004-04-04 04:04:04');");
 113     stmt->execute(rows);
 114     rows=0;
 115     stmt->prepare("INSERT INTO t1 VALUES(5,55,555,5555,'CSQL5','LAKSHYA5',55.00,5555.00,'2005-05-05','05:05:05','2005-05-05 05:05:05');");
 116     stmt->execute(rows);
 117     rows=0;
 118     stmt->prepare("INSERT INTO t1 VALUES(6,66,666,6666,'CSQL6','LAKSHYA6',66.00,6666.00,'2006-06-06','06:06:06','2006-06-06 06:06:06');");
 119     stmt->execute(rows);
 120     rows=0;
 121     stmt->prepare("INSERT INTO t1 VALUES(7,77,777,7777,'CSQL7','LAKSHYA7',77.00,7777.00,'2007-07-07','07:07:07','2007-07-07 07:07:07');");
 122     stmt->execute(rows);
 123     rows=0;
 124     stmt->prepare("INSERT INTO t1 VALUES(8,88,888,8888,'CSQL8','LAKSHYA8',88.00,8888.00,'2008-08-08','08:08:08','2008-08-08 08:08:08');");
 125     stmt->execute(rows);
 126     rows=0;
 127     stmt->prepare("INSERT INTO t1 VALUES(9,99,999,9999,'CSQL9','LAKSHYA9',99.00,9999.00,'2009-09-09','09:09:09','2009-09-09 09:09:09');");
 128     stmt->execute(rows);
 129     con->commit();
 130     stmt->free();
 131
 132     char f1var;
 133     short int f2var;
 134     int f3var;
 135     long long f4var;
 136     char f5var[20];
 137     char f6var[32];
 138     float f7var;
 139     double f8var;
 140     Date f9var;
 141     Time f10var;
 142     TimeStamp f11var;
 143
 144 //Fetching records after insert
 145     printf("SELECT * FROM t1;\n");
 146     strcpy(statement,"SELECT * FROM t1;");
 147     rv = stmt->prepare(statement);
 148     if(rv!=OK) { delete stmt; delete con; return 6; }
 149     stmt->bindField(1,&f1var);
 150     stmt->bindField(2,&f2var);
 151     stmt->bindField(3,&f3var);
 152     stmt->bindField(4,&f4var);
 153     stmt->bindField(5,f5var);
 154     stmt->bindField(6,f6var);
 155     stmt->bindField(7,&f7var);
 156     stmt->bindField(8,&f8var);
 157     stmt->bindField(9,&f9var);
 158     stmt->bindField(10,&f10var);
 159     stmt->bindField(11,&f11var);
 160     int count=0;
 161     rv = con->beginTrans();
 162     if(rv!=OK)return 7;
 163     stmt->execute(rows);
 164     while(stmt->fetch() !=NULL) {
 165         if(stmt->isFldNull(1)) printf("f1=NULL | ");
 166         else printf("f1=%d | ", f1var);
 167         if(stmt->isFldNull(2)) printf("f2(=NULL | ");
 168         else printf("f2(=%d | ", f2var);
 169         if(stmt->isFldNull(3)) printf("f3=NULL | ");
 170         else printf("f3=%d | ", f3var);
 171         if(stmt->isFldNull(4)) printf("f4=NULL | ");
 172         else printf("f4=%lld | ", f4var);
 173         if(stmt->isFldNull(5)) printf("f5=NULL | ");
 174         else printf("f5=%s | ", f5var);
 175         if(stmt->isFldNull(6)) printf("f6=NULL | ");
 176         else printf("f6=%s | ", f6var);
 177         if(stmt->isFldNull(7)) printf("f7=NULL | ");
 178         else printf("f7=%f | ", f7var);
 179         if(stmt->isFldNull(8)) printf("f8=NULL | ");
 180         else printf("f8=%lf | ", f8var);
 181         if(stmt->isFldNull(9)) printf("f9=NULL | ");
 182         else printf("f9=%02d-%02d-%02d | ", f9var.year(),f9var.month(),f9var.dayOfMonth());
 183         if(stmt->isFldNull(10)) printf("f10=NULL | ");
 184         else printf("f10=%02d:%02d:%02d | ", f10var.hours(),f10var.minutes(),f10var.seconds());
 185         if(stmt->isFldNull(11)) printf("f11=NULL | ");
 186         else printf("f11=%d-%d-%d %d:%d:%d | ", f11var.year(),f11var.month(),f11var.dayOfMonth(),f11var.hours(),f11var.minutes(),f11var.seconds());
 187         printf("\n");
 188         count++;
 189     }
 190     stmt->free();
 191     rv = con->commit();
 192     printf("%d rows selected\n",count);
 193
 194 //Updating records.
 195     con->beginTrans();
 196     printf("UPDATE t1 SET f1=10, f2=100, f3=1000, f4=10000, f5='CSQLMMDB', f6='LAKSHYA_BANGALORE', f7=100, f8=10000,f9='2009-01-10', f10='01:01:10', f11='2009-01-10 01:01:10' WHERE f1=1;\n");
 197     strcpy(statement,"UPDATE t1 SET f1=10, f2=100, f3=1000, f4=10000, f5='CSQLMMDB', f6='LAKSHYA_BANGALORE', f7=100, f8=10000,f9='2009-01-10', f10='01:01:10', f11='2009-01-10 01:01:10' WHERE f1=1;");
 198     rv = stmt->prepare(statement);
 199     rv = stmt->execute(rows);
 200     printf("UPDATE t1 SET f1=20, f2=200, f3=2000, f4=20000, f5='CSQLMMDB2', f6='LAKSHYA_BANGALORE2', f7=200, f8=20000,f9='2009-01-11', f10='01:01:11', f11='2009-01-11 01:01:11' WHERE f2=100;\n");
 201     strcpy(statement,"UPDATE t1 SET f1=20, f2=200, f3=2000, f4=20000, f5='CSQLMMDB2', f6='LAKSHYA_BANGALORE2', f7=200, f8=20000,f9='2009-01-11', f10='01:01:11', f11='2009-01-11 01:01:11' WHERE f2=100;");
 202     rv = stmt->prepare(statement);
 203     rv = stmt->execute(rows);
 204     printf("UPDATE t1 SET f1=30, f2=300, f3=3000, f4=30000, f5='CSQLMMDB3', f6='LAKSHYA_BANGALORE3', f7=300, f8=30000,f9='2009-01-12', f10='01:01:12', f11='2009-01-12 01:01:12' WHERE f3=2000;\n");
 205     strcpy(statement,"UPDATE t1 SET f1=30, f2=300, f3=3000, f4=30000, f5='CSQLMMDB3', f6='LAKSHYA_BANGALORE3', f7=300, f8=30000,f9='2009-01-12', f10='01:01:12', f11='2009-01-12 01:01:12' WHERE f3=2000;");
 206     rv = stmt->prepare(statement);
 207     rv = stmt->execute(rows);
 208     printf("UPDATE t1 SET f1=40, f2=400, f3=4000, f4=40000, f5='CSQLMMDB4', f6='LAKSHYA_BANGALORE4', f7=400, f8=40000,f9='2009-01-13', f10='01:01:13', f11='2009-01-13 01:01:13' WHERE f4=30000;\n");
 209     strcpy(statement,"UPDATE t1 SET f1=40, f2=400, f3=4000, f4=40000, f5='CSQLMMDB4', f6='LAKSHYA_BANGALORE4', f7=400, f8=40000,f9='2009-01-13', f10='01:01:13', f11='2009-01-13 01:01:13' WHERE f4=30000;");
 210     rv = stmt->prepare(statement);
 211     rv = stmt->execute(rows);
 212     printf("UPDATE t1 SET f1=50, f2=500, f3=5000, f4=50000, f5='CSQLMMDB5', f6='LAKSHYA_BANGALORE5', f7=500, f8=50000,f9='2009-01-14', f10='01:01:14', f11='2009-01-14 01:01:14' WHERE f5='CSQLMMDB4';\n");
 213     strcpy(statement,"UPDATE t1 SET f1=50, f2=500, f3=5000, f4=50000, f5='CSQLMMDB5', f6='LAKSHYA_BANGALORE5', f7=500, f8=50000,f9='2009-01-14', f10='01:01:14', f11='2009-01-14 01:01:14' WHERE f5='CSQLMMDB4';");
 214     rv = stmt->prepare(statement);
 215     rv = stmt->execute(rows);
 216     printf("UPDATE t1 SET f1=60, f2=600, f3=6000, f4=60000, f5='CSQLMMDB6', f6='LAKSHYA_BANGALORE6', f7=600, f8=60000,f9='2009-01-16', f10='01:01:16', f11='2009-01-16 01:01:16' WHERE f6='LAKSHYA_BANGALORE5';\n");
 217     strcpy(statement,"UPDATE t1 SET f1=60, f2=600, f3=6000, f4=60000, f5='CSQLMMDB6', f6='LAKSHYA_BANGALORE6', f7=600, f8=60000,f9='2009-01-16', f10='01:01:16', f11='2009-01-16 01:01:16' WHERE f6='LAKSHYA_BANGALORE5';");
 218     rv = stmt->prepare(statement);
 219     rv = stmt->execute(rows);
 220     printf("UPDATE t1 SET f1=70, f2=700, f3=7000, f4=70000, f5='CSQLMMDB7', f6='LAKSHYA_BANGALORE7', f7=700, f8=70000,f9='2009-01-17', f10='01:01:17', f11='2009-01-17 01:01:17' WHERE f7=600;\n");
 221     strcpy(statement,"UPDATE t1 SET f1=70, f2=700, f3=7000, f4=70000, f5='CSQLMMDB7', f6='LAKSHYA_BANGALORE7', f7=700, f8=70000,f9='2009-01-17', f10='01:01:17', f11='2009-01-17 01:01:17' WHERE f7=600;");
 222     rv = stmt->prepare(statement);
 223     rv = stmt->execute(rows);
 224     printf("UPDATE t1 SET f1=80, f2=800, f3=8000, f4=80000, f5='CSQLMMDB8', f6='LAKSHYA_BANGALORE8', f7=800, f8=80000,f9='2009-01-18', f10='01:01:18', f11='2009-01-18 01:01:18' WHERE f8=70000;\n");
 225     strcpy(statement,"UPDATE t1 SET f1=80, f2=800, f3=8000, f4=80000, f5='CSQLMMDB8', f6='LAKSHYA_BANGALORE8', f7=800, f8=80000,f9='2009-01-18', f10='01:01:18', f11='2009-01-18 01:01:18' WHERE f8=70000;");
 226     rv = stmt->prepare(statement);
 227     rv = stmt->execute(rows);
 228     printf("UPDATE t1 SET f1=90, f2=900, f3=9000, f4=90000, f5='CSQLMMDB9', f6='LAKSHYA_BANGALORE9', f7=900, f8=90000,f9='2009-01-19', f10='01:01:19', f11='2009-01-19 01:01:19' WHERE f9='2009-01-18';\n");
 229     strcpy(statement,"UPDATE t1 SET f1=90, f2=900, f3=9000, f4=90000, f5='CSQLMMDB9', f6='LAKSHYA_BANGALORE9', f7=900, f8=90000,f9='2009-01-19', f10='01:01:19', f11='2009-01-19 01:01:19' WHERE f9='2009-01-18';");
 230     rv = stmt->prepare(statement);
 231     rv = stmt->execute(rows);
 232     printf("UPDATE t1 SET f1=100, f2=1000, f3=10000, f4=100000, f5='CSQLMMDB10', f6='LAKSHYA_BANGALORE10', f7=1000, f8=100000,f9='2009-01-20', f10='01:01:20', f11='2009-01-20 01:01:20' WHERE f10='01:01:19';\n");
 233     strcpy(statement,"UPDATE t1 SET f1=100, f2=1000, f3=10000, f4=100000, f5='CSQLMMDB10', f6='LAKSHYA_BANGALORE10', f7=1000, f8=100000,f9='2009-01-20', f10='01:01:20', f11='2009-01-20 01:01:20' WHERE f10='01:01:19';");
 234     rv = stmt->prepare(statement);
 235     rv = stmt->execute(rows);
 236     printf("UPDATE t1 SET f1=110, f2=1100, f3=11000, f4=110000, f5='CSQLMMDB11', f6='LAKSHYA_BANGALORE11', f7=1100, f8=110000,f9='2009-09-09', f10='09:09:09', f11='2009-09-09 09:09:09' WHERE f11='2009-01-20 01:01:20';\n");
 237     strcpy(statement,"UPDATE t1 SET f1=110, f2=1100, f3=11000, f4=110000, f5='CSQLMMDB11', f6='LAKSHYA_BANGALORE11', f7=1100, f8=110000,f9='2009-09-09', f10='09:09:09', f11='2009-09-09 09:09:09' WHERE f11='2009-01-20 01:01:20';");
 238     rv = stmt->prepare(statement);
 239     rv = stmt->execute(rows);
 240     con->commit();
 241     stmt->free();
 242
 243 //Fetching records
 244     printf("SELECT * FROM t1;\n");
 245     strcpy(statement,"SELECT * FROM t1;");
 246     rv = stmt->prepare(statement);
 247     if(rv!=OK) { delete stmt; delete con; return 6; }
 248     stmt->bindField(1,&f1var);
 249     stmt->bindField(2,&f2var);
 250     stmt->bindField(3,&f3var);
 251     stmt->bindField(4,&f4var);
 252     stmt->bindField(5,f5var);
 253     stmt->bindField(6,f6var);
 254     stmt->bindField(7,&f7var);
 255     stmt->bindField(8,&f8var);
 256     stmt->bindField(9,&f9var);
 257     stmt->bindField(10,&f10var);
 258     stmt->bindField(11,&f11var);
 259     count=0;
 260     rv = con->beginTrans();
 261     if(rv!=OK)return 7;
 262     stmt->execute(rows);
 263     while(stmt->fetch() !=NULL) {
 264         if(stmt->isFldNull(1)) printf("f1=NULL | ");
 265         else printf("f1=%d | ", f1var);
 266         if(stmt->isFldNull(2)) printf("f2(=NULL | ");
 267         else printf("f2(=%d | ", f2var);
 268         if(stmt->isFldNull(3)) printf("f3=NULL | ");
 269         else printf("f3=%d | ", f3var);
 270         if(stmt->isFldNull(4)) printf("f4=NULL | ");
 271         else printf("f4=%lld | ", f4var);
 272         if(stmt->isFldNull(5)) printf("f5=NULL | ");
 273         else printf("f5=%s | ", f5var);
 274         if(stmt->isFldNull(6)) printf("f6=NULL | ");
 275         else printf("f6=%s | ", f6var);
 276         if(stmt->isFldNull(7)) printf("f7=NULL | ");
 277         else printf("f7=%f | ", f7var);
 278         if(stmt->isFldNull(8)) printf("f8=NULL | ");
 279         else printf("f8=%lf | ", f8var);
 280         if(stmt->isFldNull(9)) printf("f9=NULL | ");
 281         else printf("f9=%02d-%02d-%02d | ", f9var.year(),f9var.month(),f9var.dayOfMonth());
 282         if(stmt->isFldNull(10)) printf("f10=NULL | ");
 283         else printf("f10=%02d:%02d:%02d | ", f10var.hours(),f10var.minutes(),f10var.seconds());
 284         if(stmt->isFldNull(11)) printf("f11=NULL | ");
 285         else printf("f11=%d-%d-%d %d:%d:%d | ", f11var.year(),f11var.month(),f11var.dayOfMonth(),f11var.hours(),f11var.minutes(),f11var.seconds());
 286         printf("\n");
 287         count++;
 288     }
 289     stmt->free();
 290     rv = con->commit();
 291     printf("%d rows selected\n",count);
 292
 293 //Testing "<" operator
 294     printf("UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f1<3;\n");
 295     strcpy(statement,"UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f1<3;");
 296     rv = stmt->prepare(statement);
 297     rv = stmt->execute(rows);
 298
 299     printf("UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f2<3;\n");
 300     strcpy(statement,"UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f2<3;");
 301     rv = stmt->prepare(statement);
 302     rv = stmt->execute(rows);
 303     printf("UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f3<3;\n");
 304     strcpy(statement,"UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f3<3;");
 305     rv = stmt->prepare(statement);
 306     rv = stmt->execute(rows);
 307     printf("UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f4<3;\n");
 308     strcpy(statement,"UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f4<3;");
 309     rv = stmt->prepare(statement);
 310     rv = stmt->execute(rows);
 311     printf("UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f5<'CSQL3';\n");
 312     strcpy(statement,"UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f5<'CSQL3';");
 313     rv = stmt->prepare(statement);
 314     rv = stmt->execute(rows);
 315     printf("UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f6<'LAKSHYA3';\n");
 316     strcpy(statement,"UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f6<'LAKSHYA3';");
 317     rv = stmt->prepare(statement);
 318     rv = stmt->execute(rows);
 319     printf(" UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f7<3;\n");
 320     strcpy(statement," UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f7<3;");
 321     rv = stmt->prepare(statement);
 322     rv = stmt->execute(rows);
 323     printf("UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f8<3;\n");
 324     strcpy(statement,"UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f8<3;");
 325     rv = stmt->prepare(statement);
 326     rv = stmt->execute(rows);
 327     printf("UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f9<'2003/03/03';\n");
 328     strcpy(statement,"UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f9<'2003/03/03';");
 329     rv = stmt->prepare(statement);
 330     rv = stmt->execute(rows);
 331     printf("UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f10<'03:03:03';\n");
 332     strcpy(statement,"UPDATE t1 SET f1=2, f2=2, f3=2, f4=2, f5='CSQL2', f6='LAKSHYA2', f7=2, f8=2,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f10<'03:03:03';");
 333     rv = stmt->prepare(statement);
 334     rv = stmt->execute(rows);
 335     printf("UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f11<'2003/03/03 03:03:03';\n");
 336     strcpy(statement,"UPDATE t1 SET f1=1, f2=1, f3=1, f4=1, f5='CSQL1', f6='LAKSHYA1', f7=1, f8=1,f9='2001-01-01', f10='01:01:01', f11='2001-01-01 01:01:01' WHERE f11<'2003/03/03 03:03:03';");
 337     rv = stmt->prepare(statement);
 338     rv = stmt->execute(rows);
 339
 340 //Fetching records
 341     printf("SELECT * FROM t1;\n");
 342     strcpy(statement,"SELECT * FROM t1;");
 343     rv = stmt->prepare(statement);
 344     if(rv!=OK) { delete stmt; delete con; return 6; }
 345     stmt->bindField(1,&f1var);
 346     stmt->bindField(2,&f2var);
 347     stmt->bindField(3,&f3var);
 348     stmt->bindField(4,&f4var);
 349     stmt->bindField(5,f5var);
 350     stmt->bindField(6,f6var);
 351     stmt->bindField(7,&f7var);
 352     stmt->bindField(8,&f8var);
 353     stmt->bindField(9,&f9var);
 354     stmt->bindField(10,&f10var);
 355     stmt->bindField(11,&f11var);
 356     count=0;
 357     rv = con->beginTrans();
 358     if(rv!=OK)return 7;
 359     stmt->execute(rows);
 360     while(stmt->fetch() !=NULL) {
 361         if(stmt->isFldNull(1)) printf("f1=NULL | ");
 362         else printf("f1=%d | ", f1var);
 363         if(stmt->isFldNull(2)) printf("f2(=NULL | ");
 364         else printf("f2(=%d | ", f2var);
 365         if(stmt->isFldNull(3)) printf("f3=NULL | ");
 366         else printf("f3=%d | ", f3var);
 367         if(stmt->isFldNull(4)) printf("f4=NULL | ");
 368         else printf("f4=%lld | ", f4var);
 369         if(stmt->isFldNull(5)) printf("f5=NULL | ");
 370         else printf("f5=%s | ", f5var);
 371         if(stmt->isFldNull(6)) printf("f6=NULL | ");
 372         else printf("f6=%s | ", f6var);
 373         if(stmt->isFldNull(7)) printf("f7=NULL | ");
 374         else printf("f7=%f | ", f7var);
 375         if(stmt->isFldNull(8)) printf("f8=NULL | ");
 376         else printf("f8=%lf | ", f8var);
 377         if(stmt->isFldNull(9)) printf("f9=NULL | ");
 378         else printf("f9=%02d-%02d-%02d | ", f9var.year(),f9var.month(),f9var.dayOfMonth());
 379         if(stmt->isFldNull(10)) printf("f10=NULL | ");
 380         else printf("f10=%02d:%02d:%02d | ", f10var.hours(),f10var.minutes(),f10var.seconds());
 381         if(stmt->isFldNull(11)) printf("f11=NULL | ");
 382         else printf("f11=%d-%d-%d %d:%d:%d | ", f11var.year(),f11var.month(),f11var.dayOfMonth(),f11var.hours(),f11var.minutes(),f11var.seconds());
 383         printf("\n");
 384         count++;
 385     }
 386     stmt->free();
 387     rv = con->commit();
 388     printf("%d rows selected\n",count);
 389
 390
 391 //Testing "<=" operator
 392     printf("UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f1<=4;\n");
 393     strcpy(statement,"UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f1<=4;");
 394     rv = stmt->prepare(statement);
 395     rv = stmt->execute(rows);
 396     printf("UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f2<=4;\n");
 397     strcpy(statement,"UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f2<=4;");
 398     rv = stmt->prepare(statement);
 399     rv = stmt->execute(rows);
 400     printf("UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f3<=4;\n");
 401     strcpy(statement,"UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f3<=4;");
 402     rv = stmt->prepare(statement);
 403     rv = stmt->execute(rows);
 404     printf("UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f4<=4;\n");
 405     strcpy(statement,"UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f4<=4;");
 406     rv = stmt->prepare(statement);
 407     rv = stmt->execute(rows);
 408     printf("UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f5<='CSQL4';\n");
 409     strcpy(statement,"UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f5<='CSQL4';");
 410     rv = stmt->prepare(statement);
 411     rv = stmt->execute(rows);
 412     printf("UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f6<='LAKSHYA4';\n");
 413     strcpy(statement,"UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f6<='LAKSHYA4';");
 414     rv = stmt->prepare(statement);
 415     rv = stmt->execute(rows);
 416     printf("UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f7<=4;\n");
 417     strcpy(statement,"UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f7<=4;");
 418     rv = stmt->prepare(statement);
 419     rv = stmt->execute(rows);
 420     printf("UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f8<=4;\n");
 421     strcpy(statement,"UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f8<=4;");
 422     rv = stmt->prepare(statement);
 423     rv = stmt->execute(rows);
 424     printf("UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f9<='2004-04-04';\n");
 425     strcpy(statement,"UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f9<='2004-04-04';");
 426     rv = stmt->prepare(statement);
 427     rv = stmt->execute(rows);
 428     printf("UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f10<='04:04:04';\n");
 429     strcpy(statement,"UPDATE t1 SET f1=4, f2=4, f3=4, f4=4, f5='CSQL4', f6='LAKSHYA4', f7=4, f8=4,f9='2004-04-04', f10='04:04:04', f11='2004-04-04 04:04:04' WHERE f10<='04:04:04';");
 430     rv = stmt->prepare(statement);
 431     rv = stmt->execute(rows);
 432     printf("UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f11<='2004-04-04 04:04:04';\n");
 433     strcpy(statement,"UPDATE t1 SET f1=3, f2=3, f3=3, f4=3, f5='CSQL3', f6='LAKSHYA3', f7=3, f8=3,f9='2003-03-03', f10='03:03:03', f11='2003-03-03 03:03:03' WHERE f11<='2004-04-04 04:04:04';");
 434     rv = stmt->prepare(statement);
 435     rv = stmt->execute(rows);
 436
 437 //Fetching records
 438     printf("SELECT * FROM t1;\n");
 439     strcpy(statement,"SELECT * FROM t1;");
 440     rv = stmt->prepare(statement);
 441     if(rv!=OK) { delete stmt; delete con; return 6; }
 442     stmt->bindField(1,&f1var);
 443     stmt->bindField(2,&f2var);
 444     stmt->bindField(3,&f3var);
 445     stmt->bindField(4,&f4var);
 446     stmt->bindField(5,f5var);
 447     stmt->bindField(6,f6var);
 448     stmt->bindField(7,&f7var);
 449     stmt->bindField(8,&f8var);
 450     stmt->bindField(9,&f9var);
 451     stmt->bindField(10,&f10var);
 452     stmt->bindField(11,&f11var);
 453     count=0;
 454     rv = con->beginTrans();
 455     if(rv!=OK)return 7;
 456     stmt->execute(rows);
 457     while(stmt->fetch() !=NULL) {
 458         if(stmt->isFldNull(1)) printf("f1=NULL | ");
 459         else printf("f1=%d | ", f1var);
 460         if(stmt->isFldNull(2)) printf("f2(=NULL | ");
 461         else printf("f2(=%d | ", f2var);
 462         if(stmt->isFldNull(3)) printf("f3=NULL | ");
 463         else printf("f3=%d | ", f3var);
 464         if(stmt->isFldNull(4)) printf("f4=NULL | ");
 465         else printf("f4=%lld | ", f4var);
 466         if(stmt->isFldNull(5)) printf("f5=NULL | ");
 467         else printf("f5=%s | ", f5var);
 468         if(stmt->isFldNull(6)) printf("f6=NULL | ");
 469         else printf("f6=%s | ", f6var);
 470         if(stmt->isFldNull(7)) printf("f7=NULL | ");
 471         else printf("f7=%f | ", f7var);
 472         if(stmt->isFldNull(8)) printf("f8=NULL | ");
 473         else printf("f8=%lf | ", f8var);
 474         if(stmt->isFldNull(9)) printf("f9=NULL | ");
 475         else printf("f9=%02d-%02d-%02d | ", f9var.year(),f9var.month(),f9var.dayOfMonth());
 476         if(stmt->isFldNull(10)) printf("f10=NULL | ");
 477         else printf("f10=%02d:%02d:%02d | ", f10var.hours(),f10var.minutes(),f10var.seconds());
 478         if(stmt->isFldNull(11)) printf("f11=NULL | ");
 479         else printf("f11=%d-%d-%d %d:%d:%d | ", f11var.year(),f11var.month(),f11var.dayOfMonth(),f11var.hours(),f11var.minutes(),f11var.seconds());
 480         printf("\n");
 481         count++;
 482     }
 483     stmt->free();
 484     rv = con->commit();
 485     printf("%d rows selected\n",count);
 486
 487 //Testing "!=" operator
 488     printf("UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f1!=7;\n");
 489     strcpy(statement,"UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f1!=7;");
 490     rv = stmt->prepare(statement);
 491     rv = stmt->execute(rows);
 492     printf("UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f2!=77\n");
 493     strcpy(statement,"UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f2!=77");
 494     rv = stmt->prepare(statement);
 495     rv = stmt->execute(rows);
 496     printf("UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f3!=777;\n");
 497     strcpy(statement,"UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f3!=777;");
 498     rv = stmt->prepare(statement);
 499     rv = stmt->execute(rows);
 500     printf("UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f4!=7777;\n");
 501     strcpy(statement,"UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f4!=7777;");
 502     rv = stmt->prepare(statement);
 503     rv = stmt->execute(rows);
 504     printf("UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f5!='CSQL7';\n");
 505     strcpy(statement,"UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f5!='CSQL7';");
 506     rv = stmt->prepare(statement);
 507     rv = stmt->execute(rows);
 508     printf("UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f6!='LAKSHYA7';\n");
 509     strcpy(statement,"UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f6!='LAKSHYA7';");
 510     rv = stmt->prepare(statement);
 511     rv = stmt->execute(rows);
 512     printf("UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f7!=77.000000;\n");
 513     strcpy(statement,"UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f7!=77.000000;");
 514     rv = stmt->prepare(statement);
 515     rv = stmt->execute(rows);
 516     printf("UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f8!=7777.000000;\n");
 517     strcpy(statement,"UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f8!=7777.000000;");
 518     rv = stmt->prepare(statement);
 519     rv = stmt->execute(rows);
 520     printf("UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f9!='2007/7/7';\n");
 521     strcpy(statement,"UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f9!='2007/7/7';");
 522     rv = stmt->prepare(statement);
 523     rv = stmt->execute(rows);
 524     printf("UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f10!='07:07:07';\n");
 525     strcpy(statement,"UPDATE t1 SET f1=80, f2=80, f3=80, f4=80, f5='CSQL80', f6='LAKSHYA80', f7=80, f8=80,f9='2080-08-08', f10='08:08:08', f11='2080-08-08 08:08:08' WHERE f10!='07:07:07';");
 526     rv = stmt->prepare(statement);
 527     rv = stmt->execute(rows);
 528     printf("UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f11!='2007/07/07 07:07:07';\n");
 529     strcpy(statement,"UPDATE t1 SET f1=70, f2=70, f3=70, f4=70, f5='CSQL70', f6='LAKSHYA70', f7=70, f8=70,f9='2070-07-07', f10='07:07:07', f11='2070-07-07 07:07:07' WHERE f11!='2007/07/07 07:07:07';");
 530     rv = stmt->prepare(statement);
 531     rv = stmt->execute(rows);
 532
 533 //Fetching records
 534     printf("SELECT * FROM t1;\n");
 535     strcpy(statement,"SELECT * FROM t1;");
 536     rv = stmt->prepare(statement);
 537     if(rv!=OK) { delete stmt; delete con; return 6; }
 538     stmt->bindField(1,&f1var);
 539     stmt->bindField(2,&f2var);
 540     stmt->bindField(3,&f3var);
 541     stmt->bindField(4,&f4var);
 542     stmt->bindField(5,f5var);
 543     stmt->bindField(6,f6var);
 544     stmt->bindField(7,&f7var);
 545     stmt->bindField(8,&f8var);
 546     stmt->bindField(9,&f9var);
 547     stmt->bindField(10,&f10var);
 548     stmt->bindField(11,&f11var);
 549     count=0;
 550     rv = con->beginTrans();
 551     if(rv!=OK)return 7;
 552     stmt->execute(rows);
 553     while(stmt->fetch() !=NULL) {
 554         if(stmt->isFldNull(1)) printf("f1=NULL | ");
 555         else printf("f1=%d | ", f1var);
 556         if(stmt->isFldNull(2)) printf("f2(=NULL | ");
 557         else printf("f2(=%d | ", f2var);
 558         if(stmt->isFldNull(3)) printf("f3=NULL | ");
 559         else printf("f3=%d | ", f3var);
 560         if(stmt->isFldNull(4)) printf("f4=NULL | ");
 561         else printf("f4=%lld | ", f4var);
 562         if(stmt->isFldNull(5)) printf("f5=NULL | ");
 563         else printf("f5=%s | ", f5var);
 564         if(stmt->isFldNull(6)) printf("f6=NULL | ");
 565         else printf("f6=%s | ", f6var);
 566         if(stmt->isFldNull(7)) printf("f7=NULL | ");
 567         else printf("f7=%f | ", f7var);
 568         if(stmt->isFldNull(8)) printf("f8=NULL | ");
 569         else printf("f8=%lf | ", f8var);
 570         if(stmt->isFldNull(9)) printf("f9=NULL | ");
 571         else printf("f9=%02d-%02d-%02d | ", f9var.year(),f9var.month(),f9var.dayOfMonth());
 572         if(stmt->isFldNull(10)) printf("f10=NULL | ");
 573         else printf("f10=%02d:%02d:%02d | ", f10var.hours(),f10var.minutes(),f10var.seconds());
 574         if(stmt->isFldNull(11)) printf("f11=NULL | ");
 575         else printf("f11=%d-%d-%d %d:%d:%d | ", f11var.year(),f11var.month(),f11var.dayOfMonth(),f11var.hours(),f11var.minutes(),f11var.seconds());
 576         printf("\n");
 577         count++;
 578     }
 579     stmt->free();
 580     rv = con->commit();
 581     printf("%d rows selected\n",count);
 582
 583 //Droping table
 584     strcpy(statement,"DROP TABLE t1;");
 585     rv = stmt->prepare(statement);
 586     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 12; }
 587     rv = stmt->execute(rows);
 588     if(rv!=OK) { delete stmt; con->disconnect(); delete con; return 13; }
 589     printf("Table dropped\n");
 590     stmt->free();
 591     con->disconnect();
 592     printf("Connection Closed\n");
 593
 594     delete stmt; delete con;
 595     return 0;
 596 }
 597