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