test/sqlapi/Select/selecttest5.c

   1 /*   call execute without calling prepare. it should fail.
   2
   3  *   Author : Jitendra Lenka
   4  */
   5
   6 #include<AbsSqlStatement.h>
   7 #include<SqlFactory.h>
   8
   9 int main()
  10 {
  11   DbRetVal rv = OK;
  12   AbsSqlConnection *con = SqlFactory :: createConnection(CSql);
  13   rv  = con->connect("root","manager");
  14   if(rv!=OK)return 1;
  15
  16   AbsSqlStatement *stmt = SqlFactory :: createStatement(CSql);
  17   stmt->setConnection(con);
  18   char statement[200];
  19
  20   strcpy(statement,"CREATE TABLE T1(F1 INT,F2 INT);");
  21
  22   int rows=0;
  23   /*rv = stmt->prepare(statement);
  24   if(rv!=OK)
  25   {
  26     delete stmt;
  27     delete con;
  28     return 1;
  29  }*/
  30
  31  rv  = stmt->execute(rows);
  32  printf("hello\n");
  33  if(rv!=OK)
  34   {
  35     delete stmt;
  36     delete con;
  37     printf("Execute failed without call prepare\n");
  38     return 0;
  39  }
  40  stmt->free();
  41  printf("Test script failed\n");
  42
  43
  44    delete stmt;
  45    delete con;
  46    return 1;
  47  }
  48