zmain1

#include<stdio.h>
#include<stdlib.h>
#include<string.h>
#include "sqlite3.h"
#include "sqliteInt.h"
#include "vdbe.h"
#include "vdbeInt.h"

static int callback(void *data, int argc, char **argv, char **azColName)
{
    return 0;
}

int main(int argc, char* argv[]) {
    sqlite3 *db;
    sqlite3_stmt *selectStmt;
    char *sql, *zerrmsg = 0;
    int rc;
    Vdbe *pVdbe;

    //open database
    rc = sqlite3_open("tst.db", &db);
    if (rc) {
        fprintf(stderr, "cant open database: %s \n", sqlite3_errmsg(db));
        exit(0);
    } else fprintf(stderr, "database opened successfully\n");


   sql="create table em(name text,age int);";
   //rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);

    sql = "select * from em";
    //rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);

    if (rc != SQLITE_OK)
    {
        fprintf(stderr, "SQL error: %s\n", zerrmsg);
        sqlite3_free(zerrmsg);
    }
    else fprintf(stdout, "Operation done successfully\n");

    printf("Before\n");
    sqlite3_prepare_v2(db, sql, strlen(sql) + 1, &selectStmt, NULL);
    printf("Afterprep\n");

    sqlite3_close(db);

return 0;
}