Re: [sqlite] Prepare and exec

2011-05-23 Thread Dev_lex
ror in it? I've only one line in my table, ans 4 columns, that's why I've done i=0 to 3. Simon Slavin-3 wrote: > > > On 23 May 2011, at 2:05pm, Dev_lex wrote: > >> Well I know that _step is not a callback, but I have a callback to call.. >> With _exec I can call it without

Re: [sqlite] Prepare and exec

2011-05-23 Thread Dev_lex
Well that's good, I understand the concept. I'm going to write a small code for this then ! Thanks a lot for your help ! Simon Slavin-3 wrote: > > > On 23 May 2011, at 2:05pm, Dev_lex wrote: > >> Well I know that _step is not a callback, but I have a callback to call.. &

Re: [sqlite] Prepare and exec

2011-05-23 Thread Dev_lex
Simon Slavin-3 wrote: > > > On 23 May 2011, at 1:50pm, Dev_lex wrote: > >> I would like to do this : >> >> sqlite3_exec(query_handle.db,"SELECT * FROM DHSS", callback, 0, NULL); >> >> But I need to prepare the statement.. So I can prepa

[sqlite] Prepare and exec

2011-05-23 Thread Dev_lex
Hello everyone ! I've got a new question : I would like to do this : sqlite3_exec(query_handle.db,"SELECT * FROM DHSS", callback, 0, NULL); But I need to prepare the statement.. So I can prepare the statement : "SELECT * FROM DHSS" , but how can I call the callback with sqlite3_step? I hope

Re: [sqlite] Unknown parameter for prepare_v2

2011-05-20 Thread Dev_lex
Forget my last post.. The error was that I didn't initialize pzTail to NULL... That's ok :) Dev_lex wrote: > > > Simon Slavin-3 wrote: >> >> >> On 19 May 2011, at 9:35am, Dev_lex wrote: >> >>> I need to prepare the statement before to know th

Re: [sqlite] Unknown parameter for prepare_v2

2011-05-20 Thread Dev_lex
Simon Slavin-3 wrote: > > > On 19 May 2011, at 9:35am, Dev_lex wrote: > >> I need to prepare the statement before to know the name of the table, but >> I'll find an other way.. >>> >>>> >>>> I would like to do this : >>>&

Re: [sqlite] Unknown parameter for prepare_v2

2011-05-19 Thread Dev_lex
s not uniqe to sqlite, but to SQL in general. > > Martin > > Am 19.05.2011 10:04, schrieb Dev_lex: >> Hello, >> >> I've a little question about sqlite3_prepare_v2 : >> >> I would like to do this : >> >>const char *zSql = "INSERT INTO ?(

[sqlite] Unknown parameter for prepare_v2

2011-05-19 Thread Dev_lex
Hello, I've a little question about sqlite3_prepare_v2 : I would like to do this : const char *zSql = "INSERT INTO ?(ID, MyData) VALUES('1',?)"; if(ppStmt) { sqlite3_bind_parameter_name(ppStmt, "atest"); sqlite3_bind_blob(ppStmt, 2, , sizeof(blob), SQLITE_TRANSIENT);