Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows

http://www.mail-archive.com/sqlite-users@sqlite.org/msg34453.html On Mon, Oct 13, 2008 at 6:52 PM, Doug <[EMAIL PROTECTED]> wrote: > I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN > when doing an insert. When that fails, I can use the debugger to go back up > and step

Re: [sqlite] Efficient updating of arbitrary columns.

On Oct 14, 2008, at 4:26 PM, Peter van Hardenberg wrote: > Hi all, > > We're using SQLite to back the media collection in Songbird, and our > database includes a table which often has a varying set of columns > updated. At the moment, I'm using a set of prepared statements that > look like

[sqlite] Efficient updating of arbitrary columns.

Hi all, We're using SQLite to back the media collection in Songbird, and our database includes a table which often has a varying set of columns updated. At the moment, I'm using a set of prepared statements that look like this: UPDATE table SET columnN = ? WHERE table_id = ?; I talked with

[sqlite] Problem : SQLite Database error

Heya guys, iv got a database which was made my a program called BluePhoneElite, its a Mac OS X piece of software which pairs with a mobile phone over bluetooth to allow messages and calls to be managed from the computer... awesome piece of software untill it breaks. Somehow the database

Re: [sqlite] transaction question

On Oct 14, 2008, at 9:06 PM, Gene Allen wrote: > I have a large sqlite database and I'm inserting a bunch of records > into it. > My question is this..shouldn't the -journal be getting larger since > I've > wrapped all the inserts inside a transaction? > > > > I'm watching the file sizes

Re: [sqlite] Foreign Key Triggers: ABORT, FAIL, or ROLLBACK

On Oct 14, 2008, at 1:07 AM, John Belli wrote: > What is the recommended conflict to raise during an FK enforcement > trigger? I'm not asking about how to create the triggers, I've figured > that part out; I just want to know which conflict should be used. I > think I'm asking, which do other db

[sqlite] transaction question

I have a large sqlite database and I'm inserting a bunch of records into it. My question is this..shouldn't the -journal be getting larger since I've wrapped all the inserts inside a transaction? I'm watching the file sizes change and the main file is getting larger, but the journal files is

Re: [sqlite] Compile SQLite3 for MS Windows Driver Kit user-mode application

Hi again, First, I am not an expert in WDK programming. But there are a few nice samples very close to what I need and thus I tried to compile a WDK sample with the sqlite3 DLL. The sample is a minifilter driver, which consists of two parts: the minifilter driver itself, which runs in

Re: [sqlite] problem with sqlite3_exec() and select sql statemant

Use the correct SQL delimiter for a literal - single quotes, e.g. 'google.com'. Hari wrote: > Hi as i am new to sqlite. > I have problem when i am using sqlite3_exec() function with select > as i am using sqlite3_open() to opening database > then creating table and inserting some information

Re: [sqlite] sqlite3_open() problem

I run sqlite3.exe under Windows 95 like this: C:\sqlite3 test sqlite>create table t(id); Then sqlite3 crashes. Leandro dos Santos Ribeiro wrote: > Leandro dos Santos Ribeiro wrote: > >> D. Richard Hipp wrote: >> >> >>> On Oct 10, 2008, at 4:59 PM, <[EMAIL PROTECTED]> <[EMAIL

[sqlite] Foreign Key Triggers: ABORT, FAIL, or ROLLBACK

What is the recommended conflict to raise during an FK enforcement trigger? I'm not asking about how to create the triggers, I've figured that part out; I just want to know which conflict should be used. I think I'm asking, which do other db systems tend to use? JAB -- John A. Belli Software

Re: [sqlite] Testing for existence of extension

Am Tuesday, 14. October 2008 schrieb Roger Binns: > You may want to create a ticket asking for a method of getting the names > of available extensions. See #3436. Thanks for the answer. Christoph ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] problem with sqlite3_exec() and select sql statemant

Hello Hariom, - use single quotes around text constants: select * from my_table where Primarykey='google.com' - use sqlite3_prepare and sqlite3_step to select data. First call sqlite3_prepare for your statement and then sqlite3_step in al loop until it returns SQLITE_DONE - It is not an error

Re: [sqlite] Joining 2 views

On Oct 14, 2008, at 4:39 AM, Guenther Schmidt wrote: > Hi, > > unfortunately I've hit a point where I run a query where one VIEW > joins > another VIEW. > > Both views are rather large and since there is no index on the fields > where they join the query takes very very long. (About 15 min). >

[sqlite] problem with sqlite3_exec() and select sql statemant

Hi as i am new to sqlite. I have problem when i am using sqlite3_exec() function with select as i am using sqlite3_open() to opening database then creating table and inserting some information using sqlite3_exec() and 'create table' and 'insert into' then again if i use sqlite3_exec() with select