2 Testing update on all datatypes using is null and is not null operators
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(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
7 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f1 IS NULL;
8 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f1 IS NOT NULL;
9 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f2 IS NULL;
10 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f2 IS NOT NULL;
11 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f3 IS NULL;
12 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f3 IS NOT NULL;
13 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f4 IS NULL;
14 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f4 IS NOT NULL;
15 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f5 IS NULL;
16 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f5 IS NOT NULL;
17 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f6 IS NULL;
18 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f6 IS NOT NULL;
19 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f7 IS NULL;
20 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f7 IS NOT NULL;
21 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f8 IS NULL;
22 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f8 IS NOT NULL;
23 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f9 IS NULL;
24 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f9 IS NOT NULL;
25 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f10 IS NULL;
26 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f10 IS NOT NULL;
27 UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f11 IS NULL;
28 UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f11 IS NOT NULL;
36 AbsSqlConnection
*con
= createConnection();
37 rv
= con
->connect("root","manager");
42 printf("Connection opened\n");
43 AbsSqlStatement
*stmt
= createStatement();
44 stmt
->setConnection(con
);
47 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");
48 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);");
50 rv
= stmt
->prepare(statement
);
51 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 2; }
52 rv
= stmt
->execute(rows
);
53 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 3; }
56 strcpy(statement
,"GETALLTABLES;");
58 rv
= stmt
->prepare(statement
);
59 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 4; }
61 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 5; }
62 while(stmt
->next() !=NULL
) {
63 printf("Table Name is %s\n",stmt
->getFieldValuePtr(2)); //stmt->getFieldValuePtr(2) returns the TABLE_NAME (src/sql/SqlStatement.cxx)
79 //Fetching records after Insert
80 strcpy(statement
,"SELECT * FROM t1;");
81 rv
= stmt
->prepare(statement
);
82 if(rv
!=OK
) { delete stmt
; delete con
; return 6; }
83 stmt
->bindField(1,&f1var
);
84 stmt
->bindField(2,&f2var
);
85 stmt
->bindField(3,&f3var
);
86 stmt
->bindField(4,&f4var
);
87 stmt
->bindField(5,f5var
);
88 stmt
->bindField(6,f6var
);
89 stmt
->bindField(7,&f7var
);
90 stmt
->bindField(8,&f8var
);
91 stmt
->bindField(9,&f9var
);
92 stmt
->bindField(10,&f10var
);
93 stmt
->bindField(11,&f11var
);
95 rv
= con
->beginTrans();
98 while(stmt
->fetch() !=NULL
) {
99 if(stmt
->isFldNull(1)) printf("f1(tinyint)=NULL | ");
100 else printf("f1(tinyint)=%d | ", f1var
);
101 if(stmt
->isFldNull(2)) printf("f2(smallint)=NULL | ");
102 else printf("f2(smallint)=%d | ", f2var
);
103 if(stmt
->isFldNull(3)) printf("f3(int)=NULL | ");
104 else printf("f3(int)=%d | ", f3var
);
105 if(stmt
->isFldNull(4)) printf("f4(bigint)=NULL | ");
106 else printf("f4(bigint)=%lld | ", f4var
);
107 if(stmt
->isFldNull(5)) printf("f5(char)=NULL | ");
108 else printf("f5(char)=%s | ", f5var
);
109 if(stmt
->isFldNull(6)) printf("f6(varchar)=NULL | ");
110 else printf("f6(varchar)=%s | ", f6var
);
111 if(stmt
->isFldNull(7)) printf("f7(float)=NULL | ");
112 else printf("f7(float)=%f | ", f7var
);
113 if(stmt
->isFldNull(8)) printf("f8(double)=NULL | ");
114 else printf("f8(double)=%lf | ", f8var
);
115 if(stmt
->isFldNull(9)) printf("f9(date)=NULL | ");
116 else printf("f9(date)=%02d-%02d-%02d | ", f9var
.year(),f9var
.month(),f9var
.dayOfMonth());
117 if(stmt
->isFldNull(10)) printf("f10(time)=NULL | ");
118 else printf("f10(time)=%02d:%02d:%02d | ", f10var
.hours(),f10var
.minutes(),f10var
.seconds());
119 if(stmt
->isFldNull(11)) printf("f11(timestamp)=NULL | ");
120 else printf("f11(timestamp)=%d-%d-%d %d:%d:%d | ", f11var
.year(),f11var
.month(),f11var
.dayOfMonth(),f11var
.hours(),f11var
.minutes(),f11var
.seconds());
126 printf("%d rows selected\n",count
);
131 printf("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');\n");
132 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');");
136 printf("INSERT INTO t1 VALUES(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);\n");
137 stmt
->prepare("INSERT INTO t1 VALUES(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);");
141 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f1 IS NULL;\n");
142 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f1 IS NULL;");
146 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f1 IS NOT NULL;\n");
147 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f1 IS NOT NULL;");
151 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f2 IS NULL;\n");
152 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f2 IS NULL;");
156 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f3 IS NOT NULL;\n");
157 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f3 IS NOT NULL;");
161 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f4 IS NULL;\n");
162 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f4 IS NULL;");
166 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f4 IS NOT NULL;\n");
167 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f4 IS NOT NULL;");
171 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f5 IS NULL;\n");
172 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f5 IS NULL;");
176 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f5 IS NOT NULL;\n");
177 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f5 IS NOT NULL;");
181 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f6 IS NULL;\n");
182 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f6 IS NULL;");
186 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f6 IS NOT NULL;\n");
187 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f6 IS NOT NULL;");
191 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f7 IS NULL;\n");
192 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f7 IS NULL;");
196 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f7 IS NOT NULL;\n");
197 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f7 IS NOT NULL;");
201 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f8 IS NULL;\n");
202 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f8 IS NULL;");
206 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f8 IS NOT NULL;\n");
207 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f8 IS NOT NULL;");
211 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f9 IS NULL;\n");
212 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f9 IS NULL;");
216 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f9 IS NOT NULL;\n");
217 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f9 IS NOT NULL;");
221 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f10 IS NULL;\n");
222 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f10 IS NULL;");
226 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f10 IS NOT NULL;\n");
227 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f10 IS NOT NULL;");
231 printf("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f11 IS NULL;\n");
232 stmt
->prepare("UPDATE t1 SET f1=2, f2=22, f3=222, f4=2222, f5='CSQL2', f6='LAKSHYA2', f7=22.00, f8=2222.00,f9='2002-02-02', f10='02:02:02', f11='2002-02-02 02:02:02' WHERE f11 IS NULL;");
236 printf("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f11 IS NOT NULL;\n");
237 stmt
->prepare("UPDATE t1 SET f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL,f9=NULL, f10=NULL, f11=NULL WHERE f11 IS NOT NULL;");
242 //Fetching records after update
243 strcpy(statement
,"SELECT * FROM t1;");
244 rv
= stmt
->prepare(statement
);
245 if(rv
!=OK
) { delete stmt
; delete con
; return 8; }
246 stmt
->bindField(1,&f1var
);
247 stmt
->bindField(2,&f2var
);
248 stmt
->bindField(3,&f3var
);
249 stmt
->bindField(4,&f4var
);
250 stmt
->bindField(5,f5var
);
251 stmt
->bindField(6,f6var
);
252 stmt
->bindField(7,&f7var
);
253 stmt
->bindField(8,&f8var
);
254 stmt
->bindField(9,&f9var
);
255 stmt
->bindField(10,&f10var
);
256 stmt
->bindField(11,&f11var
);
258 rv
= con
->beginTrans();
261 while(stmt
->fetch() !=NULL
) {
262 if(stmt
->isFldNull(1)) printf("f1(tinyint)=NULL | ");
263 else printf("f1(tinyint)=%d | ", f1var
);
264 if(stmt
->isFldNull(2)) printf("f2(smallint)=NULL | ");
265 else printf("f2(smallint)=%d | ", f2var
);
266 if(stmt
->isFldNull(3)) printf("f3(int)=NULL | ");
267 else printf("f3(int)=%d | ", f3var
);
268 if(stmt
->isFldNull(4)) printf("f4(bigint)=NULL | ");
269 else printf("f4(bigint)=%lld | ", f4var
);
270 if(stmt
->isFldNull(5)) printf("f5(char)=NULL | ");
271 else printf("f5(char)=%s | ", f5var
);
272 if(stmt
->isFldNull(6)) printf("f6(varchar)=NULL | ");
273 else printf("f6(varchar)=%s | ", f6var
);
274 if(stmt
->isFldNull(7)) printf("f7(float)=NULL | ");
275 else printf("f7(float)=%f | ", f7var
);
276 if(stmt
->isFldNull(8)) printf("f8(double)=NULL | ");
277 else printf("f8(double)=%lf | ", f8var
);
278 if(stmt
->isFldNull(9)) printf("f9(date)=NULL | ");
279 else printf("f9(date)=%02d-%02d-%02d | ", f9var
.year(),f9var
.month(),f9var
.dayOfMonth());
280 if(stmt
->isFldNull(10)) printf("f10(time)=NULL | ");
281 else printf("f10(time)=%02d:%02d:%02d | ", f10var
.hours(),f10var
.minutes(),f10var
.seconds());
282 if(stmt
->isFldNull(11)) printf("f11(timestamp)=NULL | ");
283 else printf("f11(timestamp)=%d-%d-%d %d:%d:%d | ", f11var
.year(),f11var
.month(),f11var
.dayOfMonth(),f11var
.hours(),f11var
.minutes(),f11var
.seconds());
289 printf("%d rows selected\n",count
);
292 strcpy(statement
,"DROP TABLE t1;");
293 rv
= stmt
->prepare(statement
);
294 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 10; }
295 rv
= stmt
->execute(rows
);
296 if(rv
!=OK
) { delete stmt
; con
->disconnect(); delete con
; return 11; }
297 printf("Table dropped\n");
300 printf("Connection Closed\n");
302 delete stmt
; delete con
;