dlang how to use sqlite3

kaspars djkraukscis at gmail.com
Tue Oct 1 02:11:31 PDT 2013


Hello everyone !
i m trying to use sqlite3  but fails
Can anybody  help me fix the errors



import core.stdc.stdio, std.string, etc.c.sqlite3;
pragma(lib, "sqlite3");


// Version 1
int DoTheCallback(void* NotUsed, int numCols ,char[][]
results,char[][] columnNames)
    {
    writef("number of colomns: ", columnNames, "\n");
    return 0;
    };

// Version 2
extern(C) int myCallback(void *a_parm, int argc, char **argv,
char **column)
{
      return 0;
}


int main()
{
     sqlite3* db;
     int code;

     char*** pazResult;
     int* pnRow;
     int* pnColumn;
     char** pzErrmsg;


     code = sqlite3_open("triphone.db", &db);
     if(SQLITE_OK != code)
     {
        printf("DB create error: %s\n", sqlite3_errmsg(db));
        return 1;
     }
     printf("DB open!\n");


     // Version 1
     sqlite3_exec(db,"SELECT * FROM
triphones",myCallback,null,null);


    // Version 2
     sqlite3_exec(db,"SELECT * FROM
triphones",cast(sqlite3_callback)&DoTheCallback,null,null);


     printf("%s \n",pzErrmsg);

     sqlite3_close(db);
     printf("DB closed.\n");

     return 0;
}

The Question is how  to use sqlite3
Above Versions not working


Version 1 return
not callable using argument types ()

Versin 2 return
number of colomns: number of colomns: number of colomns: number
of colomns:
but empty array



More information about the Digitalmars-d mailing list