Re: [sqlite] Index syntax for attached database

2006-05-21 Thread Micha Bieber
Sunday, May 21, 2006, 02:10:31, Brannon King wrote: > The documentation says to put the database name on the front of the > index name, not the table name when using the create index command. I > thought it was weird myself. Thank you, it has done the trick! I missed this in CREATE's documentat

Re: [sqlite] Index syntax for attached database

2006-05-20 Thread Brannon King
The documentation says to put the database name on the front of the index name, not the table name when using the create index command. I thought it was weird myself. Micha Bieber wrote: I'm receiving sql errors like the following "no such table: main.phs_matrices_1" when trying to create an

[sqlite] Index syntax for attached database

2006-05-20 Thread Micha Bieber
I'm receiving sql errors like the following "no such table: main.phs_matrices_1" when trying to create an index using the syntax: "CREATE INDEX IF NOT EXISTS phsm_1_idx ON phs_matrices_1 (a, b, c)" from my C++ program. The error statement is true - phs_matrices_1 doesn't belong to main, but so