Re: [sqlite] Help Creating Tables

2008-08-10 Thread jonwood
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

Re: [sqlite] Help Creating Tables

2008-08-10 Thread Igor Tandetnik
"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

2008-08-10 Thread jonwood
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.

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

2008-08-10 Thread Doug Currie
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 >

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

2008-08-10 Thread D. Richard Hipp
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 >

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

2008-08-10 Thread Igor Tandetnik
"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

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

2008-08-10 Thread CAVALO SCHMIDT
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"

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

2008-08-10 Thread Igor Tandetnik
"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?

2008-08-10 Thread CAVALO SCHMIDT
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

Re: [sqlite] Possible View bug

2008-08-10 Thread Shawn Wilsher
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

2008-08-10 Thread Vitali Lovich
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