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