The second parameter is used when there is a syntax error, this a pointer of the starting error text. I used SqLiteExplorer to read my table and it does not retrieve any data, only SqLiteExpert can ! This is why its name is "EXPERT" !
This is not a code problem, there is a problem into the table. I copied the datas from the LogLibInf table to LogLibMsg table and now all the datas from this table cannot be retrieved, but before I added the datas I could. -----Message d'origine----- From: Bogdan Ureche Sent: Monday, June 13, 2011 6:28 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT I think this line is correct as it is: INVOKE sqlite3_prepare_v2,__hSql,__lpszQuery,-1,eax,edx The second parameter is __lpszQuery (the text of the query UTF-8 encoded). The statement handle is returned at the address stored in eax and is subsequently used when calling sqlite3_step. Bogdan Ureche On Mon, Jun 13, 2011 at 10:11 AM, Black, Michael (IS) < michael.bla...@ngc.com> wrote: > You do this: > > INVOKE sqlite3_prepare_v2,__hSql,__lpszQuery,-1,eax,edx > > Then this: > > INVOKE sqlite3_step,_lpSQLStatment > > You probably want > > INVOKE sqlite3_prepare_v2,__hSql,__lpSQLStatement,-1,eax,edx > > At least from what I tell of your logic. > > > > You're not using the same variable fo the statement handle in both calls. > > > > > Michael D. Black > > Senior Scientist > > NG Information Systems > > Advanced Analytics Directorate > > > > ________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Bogdan Ureche [bogdan...@gmail.com] > Sent: Monday, June 13, 2011 9:19 AM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] A simple SELECT > > Sorry, please disregard my previous message. It seems I experienced a page > refresh issue and I didn't see your full message on the forum. > > Bogdan > > On Mon, Jun 13, 2011 at 9:16 AM, Bogdan Ureche <bogdan...@gmail.com> > wrote: > > > > > > > On Mon, Jun 13, 2011 at 8:44 AM, Moi (Ph RIO Biz) <m...@phrio.biz> wrote: > > > >> You are right, I corrected it but this is not the problem. > >> The problem is coming from only ONE table : LibLogInf. > >> I exported it, destroyed it, re-created it and re-entered the datas the > >> problem always exists ! > >> > > > > You mean you don't get any records when running your query? > > > > > >> If I made the same query with just changing the table name there is no > >> problem ! > >> Generaly, I use SqlExpert to create the query, like this I am sure of > the > >> syntax, then I copy the query to my assembler program. > >> I removed the index too. > >> Sincerally, I don't understand. > >> I have the last SqLite version too. > >> I made a vacuum, a repair, I re-indexed all the table, no errors found. > >> Is this table too small ? > >> > >> > > By the way, I hope you realize that anyone reading the messages on the > > forum is totally confused because they are not aware of the assembler > code > > you sent me. If you expect helpful replies from other forum members then > you > > should post the full description of the problem there including the > > assembler code and the expected result. Otherwise we can just continue > the > > discussion by email. > > > > So if I understand correctly, you don't get any records when running > > your > > assembler code, but you do get one record when running the query in > SQLite > > Expert. If this is correct, can you please send me the assembler code > with > > your new corrections? > > > > Bogdan > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
