Re: [sqlite] Problems with the C interface

On Tue, Aug 24, 2004 at 06:58:32PM +0200, Holger Brunck wrote: > > In my case I skip the sqlite_step() command, but I assume that the > sqlite_compile() command is the important one. You have to call sqlite_step(), or the database engine never does anything. Cheers, Matt

RE: [sqlite] Problems with the C interface

Ah sorry, my mistake. I think you need to actually call sqlite_step for the DELETE to take effect though. -Original Message- From: Holger Brunck [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 5:59 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Problems with the C interface

Re: [sqlite] Problems with the C interface

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Holger Brunck wrote: |>You need a call to sqlite_exec() too. | | Why do I need this ? I am using the second possibility to execute sql commands | instead of the sql_exec() command and in other cases it works very well: | sqlite_compile(); | sqlite_step(

Re: [sqlite] Problems with the C interface

t I assume that the sqlite_compile() command is the important one. > -Original Message- > From: Holger Brunck [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 24, 2004 5:44 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Problems with the C interface > > Hi, > I'

RE: [sqlite] Problems with the C interface

You need a call to sqlite_exec() too. -Original Message- From: Holger Brunck [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 5:44 PM To: [EMAIL PROTECTED] Subject: [sqlite] Problems with the C interface Hi, I'm using sqlite 2.8.12 and have a problem in deleting rows f

[sqlite] Problems with the C interface

Hi, I'm using sqlite 2.8.12 and have a problem in deleting rows from a database. The sql statement which don't work in my C++ code was: C++ Code Segment: sql = "DELETE FROM table_1 WHERE path='/daten2/documents/my_file.txt';"; if(SQLITE_OK != sqlite_compile(db, sql, &sqltail, &dbcursor, &dberr)) {