Re: [sqlite] How to Modify Table

Sqlite does not support modifying the unique constraints on a table: http://www.sqlite.org/lang_altertable.html So you probably need to do it the 'ol fashioned way: BEGIN; CREATE TABLE Vehicles_new ( VehicleID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FK_CustomerID INTEGER NOT NULL,

[sqlite] DISTINCT clause bug in 3.6.4?

Hello, I'm working on upgrading from sqlite 3.5.7 to 3.6.4 and while running some regression unit tests in my own app I noticed a couple failures. Upon further investigation it looks like either a bug has been introduced into sqlite between 3.5.8 and 3.6.4 or my query is wrong. Here's some sql

[sqlite] Sun acquires MySQL

Or this link if your mail client breaks it up: http://tinyurl.com/2qqaa9 - To unsubscribe, send email to

[sqlite] sqlite3_update_hook

Hello, I'm trying to use the update hook functionality. I have lookup (aka join) tables that provide many-to-many relationships between rows in other tables. The problem is when I get the delete notification for the join tables the rowid is not useful in that context. I really need to know the

RE: [sqlite] Performance Question

Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 4:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Performance Question Slater, Chad wrote: > Hello, > > I'm having trouble with the performance of one of my queries and my "sql > kung fu

[sqlite] Performance Question

Hello, I'm having trouble with the performance of one of my queries and my "sql kung fu" is limited. Any help with this problem would be greatly appreciated Here's a stripped down version of the tables I'm dealing with: CREATE TABLE A ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT )

[sqlite] Performance Question: Ordering of columns

Hello, Does the ordering of columns in a table have any impact on performance? Chad - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Performance Question

Hello, Consider the following lookup table definition: CREATE TABLE foobar ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, table1_id INTEGER NOT NULL REFERENCES table1, table2_id INTEGER NOT NULL REFERENCES table2 ); The id primary key column is not necessary for anything in my

[sqlite] Multiple prepared statements work on Windows... fails on Mac OS X

Hello, I'm using two prepared statements in a block of cross platform C++ code like this (very roughly): { sqlite3_stmt * pstmt1 = NULL; sqlite3_stmt * pstmt2 = NULL; pstmt1 = PrepareAndBind(...); // Prepare and bind one statement pstmt2 = PrepareAndBind(...); // Prepare

[sqlite] LIKE operator with prepared statements

Is it possible to use the LIKE operator with a prepared statement? I'm trying to build a query that uses binding for the text in the LIKE operation as follows: SELECT x from y WHERE y.x LIKE %?% ; ...And binding text to the positional parameter in hopes to get: SELECT x from y WHERE y.x LIKE