I copied your SqLite3 dll to my program folder and get the same result, that means none. I changed SqLiteExpert to use external library and the query gives the expected result.
That means this is not a SqLite bug (I would be suprised to find one), but my assembler code is ok. Could it be a problem into the database ? This is the only way where I can find a problem. If my code was wrong (I used since many months), using others tables would give wrong result, but it works fine with others tables. I have no idea. I submitted the problem to sqlite.org but did not get any answer. -----Message d'origine----- From: Bogdan Ureche Sent: Monday, June 13, 2011 4:19 PM To: General Discussion of SQLite Database Subject: 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
