[sqlite] How to close a cursor?

All, how do I close a cursor with SQLite --> I want to stop processing a SELECT before sqlite3_step() returns SQLITE_DONE... Is sqlite3_interrupt() the right way? Does sqlite3_interrupt() deletes the prepared SQL-Statement? Thank you, Michael

[sqlite] Problem auto_increment

Hi...! I am developing with SQLite in these days but I am having problem creating auto_increment ID. I looked at FAQ section, but I couldn't find the solution. I am using sqlite 3.08 at the moment. Here is the sample statement: sqlite>create table fruits (id int primary key, name varchar(50)

Re: [sqlite] How can SQLite return indication of where SQL failed?

> >Subject: Re: [sqlite] How can SQLite return indication of where SQL failed? > From: "Peter Bartholdsson" <[EMAIL PROTECTED]> > Date: Mon, 17 Jan 2005 03:21:25 +0100 > To: sqlite-users@sqlite.org > >On Sun, 16 Jan 2005 02:42:52 -0800, <[EMAIL PROTECTED]> wrote: > >> I'm using Delphi 4 and

Re: [sqlite] How can SQLite return indication of where SQL failed?

On Sun, 16 Jan 2005 02:42:52 -0800, <[EMAIL PROTECTED]> wrote: I'm using Delphi 4 and various versions of SQLite wrapper. To begin, my only desire is to write SQL in a text box and execute it. What I'd like if a pointer to the place in the SQL where the syntax fails, and I'm presuming the in-DLL pa

Re: [sqlite] problem with queries using group by

D. Richard Hipp wrote: SQLite has never "allowed" queries to have a GROUP BY clause unless there is an aggregate function in the result set. I belive the documentation says as much. Maybe it does somewhere else, but the Syntax page, under Select, says: "The GROUP BY clauses causes one or more row

RE: [sqlite] wchar for sqlite prolem

Thanks jthomps, I start getting it to work. -Original Message- From: Jeff Thompson [mailto:[EMAIL PROTECTED] Sent: Saturday, January 15, 2005 11:22 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] wchar for sqlite prolem Hi, sqlite offers two versions of *most* functions that deal wi

[sqlite] How can SQLite return indication of where SQL failed?

I'm using Delphi 4 and various versions of SQLite wrapper. To begin, my only desire is to write SQL in a text box and execute it. What I'd like if a pointer to the place in the SQL where the syntax fails, and I'm presuming the in-DLL parser is capable of telling me that. How can I get that in