[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

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). Does

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] 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

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 using

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

[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] 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 change and

[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

[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

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

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 this:

Re: [sqlite] sqlite3_open() problem

I run sqlite3.exe under Windows 95 like this: C:\sqlite3 test sqlitecreate 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 PROTECTED] wrote:

[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] 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