Re: [sqlite] Sqlite catalog - datebase with pictures

I wrote something similar, the source might be useful to you: -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Indexing and Search speed

dcharno wrote: select types.Track,types.URL from ALBUM inner join (select * from MUSIC where Artist_Id =?) types on ALBUM.AlbumId=types.Album_Id order by ALBUM.YomiAlbumName ; How does the subquery work in this statement? I thought subqueries could only retrieve a single column. No,

[sqlite] Scope of sqlite3_changes(), how to reset it?

Hi all, some questions: 1. Is sqlite3_changes() reset to 0 when a new sqlite3_exec() is started? 2. Does a PRAGMA index_list() manipulate sqlite3_changes() in any way? 3. How can i reset sqlite3_changes() manually if its not done on sqlite3_exec()? My real problem is i have a misdesigned

Re: [sqlite] Scope of sqlite3_changes(), how to reset it?

Michael Schlenker [EMAIL PROTECTED] wrote: 1. Is sqlite3_changes() reset to 0 when a new sqlite3_exec() is started? May or may not. E.g. if you execute a SELECT statement it doesn't affect change count. 2. Does a PRAGMA index_list() manipulate sqlite3_changes() in any way? I haven't tried

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/31/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test Today I tried and installed on Solaris successfully. Both the module 1.14 and sqlite3 amalgamation. -- Radek

Re: [sqlite] DBD::SQLite::Amalgamation?

Humm... I'll keep looking. thanks On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes running both Fedora and

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. Jim,

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/31/08, P Kishor [EMAIL PROTECTED] wrote: On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/31/08, Jim Dodgen [EMAIL PROTECTED] wrote: On 3/31/08, P Kishor [EMAIL PROTECTED] wrote: On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever

Re: [sqlite] Indexing and Search speed

From: Dennis Cote [EMAIL PROTECTED] No, that's not true. A sub-query is like any other query. I have rearranged the query to make it more readable. select types.Track,types.URL from ALBUM inner join (select * from MUSIC where Artist_Id =?) as types on

[sqlite] When I try to .read I get a can't open message

I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_sourcesqlite3 test SQLite version 3.5.7 Enter .help for instructions sqlite .read test.sql; can't open test.sql; sqlite .read C:/_source/test.sql; can't open C:/_source/test.sql;

Re: [sqlite] When I try to .read I get a can't open message

On 3/31/08, Douglas McCarroll [EMAIL PROTECTED] wrote: I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_sourcesqlite3 test SQLite version 3.5.7 Enter .help for instructions sqlite .read test.sql; can't open test.sql; sqlite .read

Re: [sqlite] When I try to .read I get a can't open message

On 31-Mar-2008, at 2:11 PM, Douglas McCarroll wrote: I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_sourcesqlite3 test SQLite version 3.5.7 Enter .help for instructions sqlite .read test.sql; can't open test.sql; You shouldn't be

Re: [sqlite] When I try to .read I get a can't open message

It's the trailing semicolon. The dot commands don't require them, while SQL statements do. - Original Message From: Douglas McCarroll [EMAIL PROTECTED] To: sqlite-users@sqlite.org sqlite-users@sqlite.org Sent: Monday, March 31, 2008 2:11:35 PM Subject: [sqlite] When I try to .read I

Re: [sqlite] When I try to .read I get a can't open message

On Mon, 31 Mar 2008 17:11:35 -0400, you wrote: I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_sourcesqlite3 test SQLite version 3.5.7 Enter .help for instructions sqlite .read test.sql; can't open test.sql; sqlite .read C:/_source/test.sql;

[sqlite] SQLITE QUERY (LIKE)

Hi, how are you?? actually i'm developing a program in SQLite, and until this moment i wouldn't have any problem, but now i have a big one with a huge difficult in a query. this query is: SELECT table.code, table.name FROM table, table table2 WHERE table.code like table2.code+'%' really i

Re: [sqlite] SQLITE QUERY (LIKE)

Hi Monica, WHERE table.code like table2.code+'%' really i dont know if i am doing something wrong for sqlite, because in access my query works very good. Replace the + with || which is used to concatenate strings. In fact, I think || is the SQL standard. See:

Re: [sqlite] When I try to .read I get a can't open message

Thanks all! Yes, dropping the semicolon fixed it... On Mon, Mar 31, 2008 at 6:11 PM, Kees Nuyt [EMAIL PROTECTED] wrote: On Mon, 31 Mar 2008 17:11:35 -0400, you wrote: I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_sourcesqlite3 test

Re: [sqlite] DBD::SQLite::Amalgamation?

Hi, [...] t/06error...ok 1/2 (this never finishes) well, look in the t directory for the specific test. In my case, I see the following -- [...] my $db = DBI-connect('dbi:SQLite:foo', '', '', { RaiseError = 1, I'm not certain what the call to DBI-connect() does exactly, I

[sqlite] mem5 (buddy system) usable?

I just downloaded 3.5.7, and noticed that there is a new memory allocator mem5.c, which apparently uses the buddy system to allocate power-of-two-sized chunks of memory from a static pool. This allocator is used by defining SQLITE_POW2_MEMORY_SIZE. Is it okay to use this allocator, or is it only

[sqlite] create index with allow duplicate row

Hi All, Is sqlite3 allow to create the index(non-cluster index) with an option allow duplicate row Thanks, JL You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No

Re: [sqlite] mem5 (buddy system) usable?

On Mar 31, 2008, at 10:00 PM, Richard Klein wrote: I just downloaded 3.5.7, and noticed that there is a new memory allocator mem5.c, which apparently uses the buddy system to allocate power-of-two-sized chunks of memory from a static pool. This allocator is used by defining

Re: [sqlite] create index with allow duplicate row

Joanne Pham [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is sqlite3 allow to create the index(non-cluster index) with an option allow duplicate row Yes. Just don't use UNIQUE option in your CREATE INDEX statement. Igor Tandetnik ___