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');
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';
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';
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';
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';
69 AbsSqlConnection
*con
= createConnection();
70 rv
= con
->connect("root","manager");
75 printf("Connection opened\n");
76 AbsSqlStatement
*stmt
= createStatement();
77 stmt
->setConnection(con
);
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);");
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; }
89 strcpy(statement
,"GETALLTABLES;");
91 rv
= stmt
->prepare(statement
);
92 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 4; }
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)
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');");
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');");
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');");
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');");
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');");
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');");
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');");
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');");
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');");
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
);
161 rv
= con
->beginTrans();
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());
192 printf("%d rows selected\n",count
);
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
);
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
);
260 rv
= con
->beginTrans();
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());
291 printf("%d rows selected\n",count
);
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
);
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
);
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
);
357 rv
= con
->beginTrans();
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());
388 printf("%d rows selected\n",count
);
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
);
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
);
454 rv
= con
->beginTrans();
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());
485 printf("%d rows selected\n",count
);
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
);
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
);
550 rv
= con
->beginTrans();
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());
581 printf("%d rows selected\n",count
);
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");
592 printf("Connection Closed\n");
594 delete stmt
; delete con
;