persistentstorage/sql/TEST/t_sqlapi2.cpp
branchRCL_3
changeset 10 fa9941cf3867
parent 0 08ec8eefde2f
child 16 6b6fd149daa2
child 22 a7ba600cb39d
--- a/persistentstorage/sql/TEST/t_sqlapi2.cpp	Sat Feb 20 00:33:55 2010 +0200
+++ b/persistentstorage/sql/TEST/t_sqlapi2.cpp	Fri Mar 12 15:51:02 2010 +0200
@@ -460,6 +460,12 @@
 	err = TheStmt.ColumnName(0, colName);
 	TEST2(err, KErrNone);
 	TEST2(colName.Compare(_L("RES")), 0);
+	//Too big column index
+    err = TheStmt.ColumnName(1323, colName);
+    TEST2(err, KErrNotFound);
+    //Negative column index 
+    err = TheStmt.ColumnName(-100, colName);
+    TEST2(err, KErrNotFound);
 	TheStmt.Close();
 	//Select constant
 	err = TheStmt.Prepare(TheDb, _L("SELECT (Id + Data) AS RES, 55.89 FROM t2"));
@@ -529,7 +535,20 @@
 		TEST2(err, KErrNone);
 		TEST2(paramName.Compare(expectedParamName), 0);
 		}
+    //Too big parameter index
+    err = TheStmt.ParamName(1323, paramName);
+    TEST2(err, KErrNotFound);
+    //Negative parameter index 
+    err = TheStmt.ParamName(-100, paramName);
+    TEST2(err, KErrNotFound);
 	TheStmt.Close();
+	
+	//SQL statement without parameters
+    err = TheStmt.Prepare(TheDb, _L("INSERT INTO T (A1, A2) VALUES (1, '1')"));
+    TEST2(err, KErrNone);
+    err = TheStmt.ParamName(0, paramName);
+    TEST2(err, KErrNotFound);
+    TheStmt.Close();
 
 	// Create insert statement, then check param names
 	err = TheStmt.Prepare(TheDb, _L("INSERT INTO T (A1, A2) VALUES (:prm1, ?)"));