Re: [sqlite] Problems with the C interface

2004-08-24 Thread Matt Wilson
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

2004-08-24 Thread Drew, Stephen
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

2004-08-24 Thread Michael Roth
-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

2004-08-24 Thread Holger Brunck
> 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(); sqlite_finalize(); In my case I skip the sqlite_step() command, but I as

RE: [sqlite] Problems with the C interface

2004-08-24 Thread Drew, Stephen
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 from a data