Re: [sqlite] A simple SELECT

users-boun...@sqlite.org] on behalf of Moi (Ph RIO Biz) [m...@phrio.biz] Sent: Monday, June 13, 2011 12:08 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] A simple SELECT If I change the table name it works. I tryed the same query using SqLite3Explorer and it does not give

Re: [sqlite] A simple SELECT

The result always is the same : NONE -Message d'origine- From: Black, Michael (IS) Sent: Monday, June 13, 2011 7:56 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT Try changing just the last char. Then drop just the last char. Michael D. Black

Re: [sqlite] A simple SELECT

users-boun...@sqlite.org] on behalf of Moi (Ph RIO Biz) [m...@phrio.biz] Sent: Monday, June 13, 2011 12:08 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] A simple SELECT If I change the table name it works. I tryed the same query using SqLite3Explorer and it does not give

Re: [sqlite] A simple SELECT

If I change the table name it works. I tryed the same query using SqLite3Explorer and it does not give any result ! -Message d'origine- From: Black, Michael (IS) Sent: Monday, June 13, 2011 6:45 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT Oops

Re: [sqlite] A simple SELECT

for your help Ph RIO -Message d'origine- From: Black, Michael (IS) Sent: Monday, June 13, 2011 6:45 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT Oops...sorry...you're correct...been far too long since I've done assembler. Are we to understand

Re: [sqlite] A simple SELECT

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Bogdan Ureche [bogdan...@gmail.com] Sent: Monday, June 13, 2011 11:28 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] A simple SELECT I think this line is correct as it is: INVOKE

Re: [sqlite] A simple SELECT

Already made ! -Message d'origine- From: Simon Slavin Sent: Monday, June 13, 2011 6:39 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT On 13 Jun 2011, at 5:36pm, Moi (Ph RIO Biz) wrote: > The second parameter is used when there is a syntax er

Re: [sqlite] A simple SELECT

On 13 Jun 2011, at 5:36pm, Moi (Ph RIO Biz) wrote: > 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" !

Re: [sqlite] A simple SELECT

e 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

Re: [sqlite] A simple SELECT

s > > 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

Re: [sqlite] A simple SELECT

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 <bog

Re: [sqlite] A simple SELECT

. -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

Re: [sqlite] A simple SELECT

to use external libray to get the problem. -Message d'origine- From: Bogdan Ureche Sent: Monday, June 13, 2011 4:16 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT On Mon, Jun 13, 2011 at 8:44 AM, Moi (Ph RIO Biz) <m...@phrio.biz> wrote:

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 wrote: > > > On Mon, Jun 13, 2011 at 8:44 AM, Moi (Ph RIO Biz)

Re: [sqlite] A simple SELECT

On Mon, Jun 13, 2011 at 8:44 AM, Moi (Ph RIO 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 ! >

Re: [sqlite] A simple SELECT

. Is this table too small ? -Message d'origine- From: Bogdan Ureche Sent: Monday, June 13, 2011 3:30 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] A simple SELECT Hello Philippe, My assembler is a bit rusty, but it looks like you perform the jump to @ReadyToGetData when

Re: [sqlite] A simple SELECT

Hello Philippe, My assembler is a bit rusty, but it looks like you perform the jump to @ReadyToGetData when the return code is either SQLITE_ROW or SQLITE_DONE. You should only attempt to get the data when the return code is SQLITE_ROW. Bogdan On Mon, Jun 13, 2011 at 2:47 AM, Moi (Ph RIO Biz)

[sqlite] A simple SELECT

I encounter a big problem with a simple query. Here is the query SELECT LTRIM(RTRIM(_Libelle)) FROM LibLogInf WHERE ((_Index = 3) AND (_Langue = 1)) When I run it from SqLiteExpertPro there is no problem and I get my result. Into my program I get a NULL pointer. The table is defined like this