458 err = TheStmt.Prepare(TheDb, _L("SELECT (Id + Data) AS RES FROM t2")); |
458 err = TheStmt.Prepare(TheDb, _L("SELECT (Id + Data) AS RES FROM t2")); |
459 TEST2(err, KErrNone); |
459 TEST2(err, KErrNone); |
460 err = TheStmt.ColumnName(0, colName); |
460 err = TheStmt.ColumnName(0, colName); |
461 TEST2(err, KErrNone); |
461 TEST2(err, KErrNone); |
462 TEST2(colName.Compare(_L("RES")), 0); |
462 TEST2(colName.Compare(_L("RES")), 0); |
|
463 //Too big column index |
|
464 err = TheStmt.ColumnName(1323, colName); |
|
465 TEST2(err, KErrNotFound); |
|
466 //Negative column index |
|
467 err = TheStmt.ColumnName(-100, colName); |
|
468 TEST2(err, KErrNotFound); |
463 TheStmt.Close(); |
469 TheStmt.Close(); |
464 //Select constant |
470 //Select constant |
465 err = TheStmt.Prepare(TheDb, _L("SELECT (Id + Data) AS RES, 55.89 FROM t2")); |
471 err = TheStmt.Prepare(TheDb, _L("SELECT (Id + Data) AS RES, 55.89 FROM t2")); |
466 TEST2(err, KErrNone); |
472 TEST2(err, KErrNone); |
467 err = TheStmt.ColumnName(1, colName); |
473 err = TheStmt.ColumnName(1, colName); |
527 TEST2(paramName.Compare(expectedParamName), 0); |
533 TEST2(paramName.Compare(expectedParamName), 0); |
528 err = TheStmt.ParamName(i, paramName); |
534 err = TheStmt.ParamName(i, paramName); |
529 TEST2(err, KErrNone); |
535 TEST2(err, KErrNone); |
530 TEST2(paramName.Compare(expectedParamName), 0); |
536 TEST2(paramName.Compare(expectedParamName), 0); |
531 } |
537 } |
532 TheStmt.Close(); |
538 //Too big parameter index |
|
539 err = TheStmt.ParamName(1323, paramName); |
|
540 TEST2(err, KErrNotFound); |
|
541 //Negative parameter index |
|
542 err = TheStmt.ParamName(-100, paramName); |
|
543 TEST2(err, KErrNotFound); |
|
544 TheStmt.Close(); |
|
545 |
|
546 //SQL statement without parameters |
|
547 err = TheStmt.Prepare(TheDb, _L("INSERT INTO T (A1, A2) VALUES (1, '1')")); |
|
548 TEST2(err, KErrNone); |
|
549 err = TheStmt.ParamName(0, paramName); |
|
550 TEST2(err, KErrNotFound); |
|
551 TheStmt.Close(); |
533 |
552 |
534 // Create insert statement, then check param names |
553 // Create insert statement, then check param names |
535 err = TheStmt.Prepare(TheDb, _L("INSERT INTO T (A1, A2) VALUES (:prm1, ?)")); |
554 err = TheStmt.Prepare(TheDb, _L("INSERT INTO T (A1, A2) VALUES (:prm1, ?)")); |
536 TEST2(err, KErrNone); |
555 TEST2(err, KErrNone); |
537 |
556 |