Re: [sqlite] Help Creating Tables

Yeah, I'd seen both those links but guess I missed the specific explanation. Also, I had seen CREATE INDEX but didn't know I needed a separate statement to add an index to a table column. Many thanks! Igor Tandetnik wrote: > > "jonwood" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTEC

Re: [sqlite] Help Creating Tables

"jonwood" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm creating SQLite tables from code and could use help with the > following issues: > > 1. I'd like some tables to include foreign keys. These should be > indexed for speed, but they are neither primary keys or unique. But I >

[sqlite] Help Creating Tables

I'm creating SQLite tables from code and could use help with the following issues: 1. I'd like some tables to include foreign keys. These should be indexed for speed, but they are neither primary keys or unique. But I don't see any option to index a column without it being one of those two? 2. I

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

On Aug 10, 2008, at 2:12 PM, CAVALO SCHMIDT wrote: > salutations, using VC++ in WinXP. > > I would like to know if it's possible to import and use the > sqlite3.dll file and/or the sqlite database file as a resource in a > C++ project, so that it will be integrated to the final Win32 > executable

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

On Aug 10, 2008, at 2:12 PM, CAVALO SCHMIDT wrote: > salutations, using VC++ in WinXP. > > I would like to know if it's possible to import and use the > sqlite3.dll file and/or the sqlite database file as a resource in a > C++ project, so that it will be integrated to the final Win32 > executable

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite databaseasresource in project?

"CAVALO SCHMIDT" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > thank you for your quick response. > do you mean extracting the file > temporarily (both the database > and the DLL) to the program's > folder? Not necessarily to program folder (which you may not have write permission

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database asresource in project?

thank you for your quick response. do you mean extracting the file temporarily (both the database and the DLL) to the program's folder? but how would I do this (if this question is relevant to this list)? thank you in advance. 2008/8/10, Igor Tandetnik <[EMAIL PROTECTED]>: > "CAVALO SCHMIDT" <[EMA

Re: [sqlite] [C++] Import sqlite3.dll and/or sqlite database asresource in project?

"CAVALO SCHMIDT" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > salutations, using VC++ in WinXP. > > I would like to know if it's possible to import and use the > sqlite3.dll file and/or the sqlite database file as a resource in a > C++ project, so that it will be integrated to the

[sqlite] [C++] Import sqlite3.dll and/or sqlite database as resource in project?

salutations, using VC++ in WinXP. I would like to know if it's possible to import and use the sqlite3.dll file and/or the sqlite database file as a resource in a C++ project, so that it will be integrated to the final Win32 executable. how would it be possible to use sqlite3_open with a database f

Re: [sqlite] Possible View bug

On Sat, Aug 9, 2008 at 9:39 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Your trigger uses a curious syntax for SQL INSERT statement, along the > lines of I was hoping it was a bug in my code and not in SQLite. Thanks for spotting my fascinating syntax. Cheers, Shawn _

Re: [sqlite] db vs shell

Careful when using time. The bash built-in called time times 1 shell statement (including pipes). The binary in /usr/bin/time only times the command given - it does not span pipes. [EMAIL PROTECTED] wrote: > On Tue, Jul 29, 2008 at 02:15:54AM -0500, Robert Citek wrote: > >> Are you sure tim