[sqlite] plans for completion of INSERT OR REPLACE INTO?

a question for the sqlite developers. The inability of "INSERT OR REPLACE" to maintain referential integrity leaves me with no mechanism to implement a feature in my project that I was intending to provide. Are there any plans to add in the functionality for "INSERT OR REPLACE" to call dele

Re: [sqlite] Re bind Statement

Indiff3rence wrote: > My question is: why is necessary to reset the statement before I can rebind > it? > It should work only if I clear the old bind, no? > > You need to reset the statement so that it can be executed again from the beginning (see section 3.0 of http://www.sqlite.org/cintro.ht

Re: [sqlite] Column headers of result

BareFeet wrote: > > >>> How can I get just the column headers without all the result rows? >>> >> Turn headers on, then perform a search which gives no results. >> > > Unfortunately, the sqlite3 command line tool does not show the headers > when there are no result rows. > > Yo

Re: [sqlite] Re bind Statement

On 5 Jul 2009, at 2:02pm, Indiff3rence wrote: > Using the v2 version of prepare didn't help. I'm not sure how can I > use > sqlite_exec and 'BEGIN TRANSACTION' / 'COMMIT'. Can you please > provide an > example where you insert multiple entries to a DB. Do the command 'BEGIN TRANSACTION'. Th

Re: [sqlite] Re bind Statement

Simon Slavin-2 wrote: > > Forget all the fancy ways to speed up individual INSERT commands. You > could probably just use sqlite_exec. Your speed problem is probably > that you're not specifying that they're all the same transaction. Do > a 'BEGIN TRANSACTION' before the first one and a

Re: [sqlite] problem with SQLITE_BUSY

I used sqlite version 3.5.9. The interface sqlite3_next_stmt() is not offerd. Any other solution to check whether all statements really are finalized? From: Dan To: General Discussion of SQLite Database Sent: Saturday, July 4, 2009 10:03:47 PM Subject: Re: