Re: [sqlite] Blob newbie problem

2011-05-12 Thread StyveA
Black, Michael (IS) wrote: > > Do I understand you're still seeing a segfault? I assume you're not > seeing your "Year retrieved..." statement? > > You haven't showed us your table definition. > > Change your strcmp to strcasecmp and see if that fixes it for you. > > Michael D. Black > >

Re: [sqlite] Blob newbie problem

2011-05-12 Thread Igor Tandetnik
StyveA wrote: > I tried with your tips, and I've seen that I was missing the call of my > callback function, and now the segfault is in it.. Personally, I vastly prefer sqlite3_step / sqlite3_column* interface to sqlite3_exec. I never use the latter except for

Re: [sqlite] Blob newbie problem

2011-05-12 Thread Black, Michael (IS)
on Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of StyveA [styve.at...@technicolor.com] Sent: Thursday, May 12, 2011 7:39 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Blob newb

Re: [sqlite] Blob newbie problem

2011-05-12 Thread StyveA
Igor Tandetnik wrote: > > Prepare doesn't touch the database in any way. It just parses the text of > the statement, and prepares execution plan. Step is where the real work is > done. > > You need to issue BEGIN statement if you want to start an explicit > transaction (and then COMMIT or END

Re: [sqlite] Blob newbie problem

2011-05-12 Thread Igor Tandetnik
StyveA wrote: > For the COMMIT/END point, I though that sqlite_prepare(..) was sufficient > to do it, so Begin is mandatory? Prepare doesn't touch the database in any way. It just parses the text of the statement, and prepares execution plan. Step is where the real

Re: [sqlite] Blob newbie problem

2011-05-12 Thread StyveA
Igor Tandetnik wrote: > > StyveA wrote: >> I'm a newbie using sqlite3, and i'm trying to save in a database some >> blob >> datas (just string and integer), >> but I can't get my data back.. I just obtain a segfault.. >> I have searched in forums, but did'nt find

Re: [sqlite] Blob newbie problem

2011-05-12 Thread Igor Tandetnik
StyveA wrote: > I'm a newbie using sqlite3, and i'm trying to save in a database some blob > datas (just string and integer), > but I can't get my data back.. I just obtain a segfault.. > I have searched in forums, but did'nt find anything that could help me.. > > int

[sqlite] Blob newbie problem

2011-05-12 Thread StyveA
Hello, I'm a newbie using sqlite3, and i'm trying to save in a database some blob datas (just string and integer), but I can't get my data back.. I just obtain a segfault.. I have searched in forums, but did'nt find anything that could help me.. Here is my code :