-   Programming (
-   -   can not create sqlite table with C API (

golden_boy615 10-08-2011 05:36 AM

can not create sqlite table with C API
I am new in sqlite and this is my C code :


#include <stdio.h>
#include <sqlite3.h>
#include <string.h>

int main()
 sqlite3 *db;
 sqlite3_stmt *stmt;
 char *sqlitequery="create table ee (row INTEGER PRIMARY KEY,a INTEGER);";
 int rc = 0;

  rc = sqlite3_open("eh.db", &db);
  if( rc )
    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    rc = sqlite3_prepare_v2(db, sqlitequery, strlen(sqlitequery), &stmt, 0);
    printf("return value %d:",rc);
    if( rc )
      fprintf(stderr, "SQL error: %d : %s\n", rc, sqlite3_errmsg(db));
 return 0;

this code makes database file for me but it does not create its table named "ee" into it.
what is wrong with it?

golden_boy615 10-08-2011 05:38 AM

sorry I saved this post two times...

crabboy 10-08-2011 10:33 AM

Please follow discussion here:

All times are GMT -5. The time now is 02:58 AM.