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

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 one-liner statements like BEGIN or

Re: [sqlite] Blob newbie problem

2011-05-12 Thread Black, Michael (IS)
t NG Information 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: [sq

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 work is done. You need to is

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 anything that could help me..

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 *blob; > blob = 1990; > sqlit

[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 : http://old.nabble.com/file/p31602