Advertisement
Guest User

zmain

a guest
Jan 22nd, 2015
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 1.14 KB | None | 0 0
  1. #include<stdio.h>
  2. #include<stdlib.h>
  3. #include<string.h>
  4. #include "sqlite3.h"
  5. #include "sqliteInt.h"
  6. #include "vdbe.h"
  7. #include "vdbeInt.h"
  8.  
  9. static int callback(void *data, int argc, char **argv, char **azColName)
  10. {
  11.     return 0;
  12. }
  13.  
  14. int main(int argc, char* argv[]) {
  15.     sqlite3 *db;
  16.     sqlite3_stmt *selectStmt;
  17.     char *sql, *zerrmsg = 0;
  18.     int rc;
  19.     Vdbe *pVdbe;
  20.  
  21.     //open database
  22.     rc = sqlite3_open("tst.db", &db);
  23.     if (rc) {
  24.         fprintf(stderr, "cant open database: %s \n", sqlite3_errmsg(db));
  25.         exit(0);
  26.     } else fprintf(stderr, "database opened successfully\n");
  27.  
  28.    //create sql
  29.    sql="create table em(name text,age int);";
  30.    //rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
  31.  
  32.     sql = "select * from em";
  33.     rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
  34.  
  35.     if (rc != SQLITE_OK) {
  36.         fprintf(stderr, "SQL error: %s\n", zerrmsg);
  37.         sqlite3_free(zerrmsg);
  38.     } else fprintf(stdout, "Operation done successfully\n");
  39.  
  40.     printf("Before\n");
  41.     sqlite3_prepare_v2(db, sql, strlen(sql) + 1, &selectStmt, NULL);
  42.     printf("Afterprep\n");
  43.  
  44.     sqlite3_close(db);
  45.     return 0;
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement