Re: [sqlite] Slim down join results (all fields returned)

On 18/04/2009 2:33 PM, flakpit wrote: > If anyone else has a moment and a concrete example instead of sending me to > tutorials, feel free to step in here. If you would take a moment to read the fraction of a screen of a tutorial that I pointed you at (and which contains a concrete example),

Re: [sqlite] Slim down join results (all fields returned)

On Fri, Apr 17, 2009 at 11:33 PM, flakpit wrote: > > If anyone else has a moment and a concrete example instead of sending me to > tutorials, feel free to step in here. > > SELECT * FROM pubs                    ; I want ALL columns from the 'pubs' > table > > WHERE

Re: [sqlite] Slim down join results (all fields returned)

If anyone else has a moment and a concrete example instead of sending me to tutorials, feel free to step in here. SELECT * FROM pubs; I want ALL columns from the 'pubs' table WHERE pub_title LIKE '%salem%' ; Where the title sounds like 'salem' In the pubs table, there is

Re: [sqlite] Multi column ORDER BY across table peformance problem....

just curious; have you tried doing the select in a subquery, and then the order by in the outer query?   woody --- On Fri, 4/17/09, sorka wrote: From: sorka Subject: [sqlite] Multi column ORDER BY across table peformance problem To:

[sqlite] Multi column ORDER BY across table peformance problem....

This should be simple but apparently it isn't. I have two tables: "CREATE TABLE showing ( " "showingIdINTEGER PRIMARY KEY, " "stationId INTEGER, " "startTime INTEGER, "

Re: [sqlite] Slim down join results (all fields returned)

On 18/04/2009 8:24 AM, flakpit wrote: >> SELECT pubs.* from pubs, notes, publishers WHERE ... > > Thanks, but it didn't work the way I expected it to:) > > Now I have my query laid out a lot better and can 'slim' it down from here > > SELECT * FROM pubs > INNER JOIN notes > ON

Re: [sqlite] Slim down join results (all fields returned)

>SELECT pubs.* from pubs, notes, publishers WHERE ... Thanks, but it didn't work the way I expected it to:) Now I have my query laid out a lot better and can 'slim' it down from here SELECT * FROM pubs INNER JOIN notes ON pubs.note_id=notes.note_id ; notes. INNER JOIN publishers ON

Re: [sqlite] combine records with matching values.

"David Bicking" wrote in message news:80463.54975...@web31802.mail.mud.yahoo.com > I am trying to figure out an sql query or queries that will do the > following: > > CREATE TABLE (Key_Fields, Start, End, Value_Fields, > Primary Key(Key_Fields, Start, End)); > >

Re: [sqlite] Error : sqlite3.h:1722: parse error before string constant

Hi, Renaming the parameters did the trick. however I searched in the app for such declarations, I could not find any, But there are many third party libraries are included before that. One of them might have caused the problem. Thanks for the quick replies. Manohar On Sat, Apr 18, 2009 at 12:31

[sqlite] Strange SAVEPOINT behaviour with locking_mode=exclusive

I experience some strange behaviour with SAVEPOINT in combination with locking_mode=exclusive. Below is a script which I assembled from savepoint.text 13.1 to 13.4. Those tests run OK in normal locking mode, but fail in exclusive locking more. To reproduce, run the script below on a NEW and

[sqlite] combine records with matching values.

I am trying to figure out an sql query or queries that will do the following: CREATE TABLE (Key_Fields, Start, End, Value_Fields, Primary Key(Key_Fields, Start, End)); For any pair of records where the Key_fields are the same, and the Start of the one is the same as the end of

Re: [sqlite] Error : sqlite3.h:1722: parse error before string constant

On Apr 17, 2009, at 2:53 PM, manohar s wrote: > Hi > > I am getting this error: > > sqlite3.h:1757: parse error before string constant > > Whenever I am including the static sqlite library in my c++ app. > This is > happening with recent release 3.6.13. Earlier I never experienced any >

[sqlite] Error : sqlite3.h:1722: parse error before string constant

Hi I am getting this error: sqlite3.h:1757: parse error before string constant Whenever I am including the static sqlite library in my c++ app. This is happening with recent release 3.6.13. Earlier I never experienced any problem. In that line in the header file, This function is present:

[sqlite] Memory usage

Hello guys, I need your help in order to solve a very annoying issue with sqlite 3.6.11. I have two opened db inside my application and when I insert 180,000 rows inside a transaction I can see heap memory usage that exceeds 100MB (data is written twice so I have 2 transactions inside two

Re: [sqlite] sqlite database to xml converter??

Cruel. Just cruel. RW Ron Wilson, Engineering Project Lead, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Vinnie Sent: Friday, April 17, 2009 8:49 AM To: sqlite-users@sqlite.org Subject:

Re: [sqlite] converting sqlite db into xml

> From: candd > I want to have a sample C source for a program that convert > an sqlite > data base file to xml file. > could you help me please! Thats a pretty broad and open ended question. What exactly are you trying to accomplish here? Do you want to produce enough XML

Re: [sqlite] Can the page size cause bugs? (was Re: problems with shared cache?)

Just a follow-up in case anyone else runs into this. The issue was not related to the page size, though different page sizes could exacerbate the problem. The problem turned out to be accidentally issuing a select in the sqlite progress handler. My progress handler was repainting the GUI, and

Re: [sqlite] Error Binding Parameter to Compiled Statement

SimonDavies wrote: > > Is sqlite3_reset() being called before looping around? > Nope. And calling it resolved the issue. I didn't realize that was necessary. Thanks much! Jonathan -- View this message in context:

Re: [sqlite] Error Binding Parameter to Compiled Statement

2009/4/17 jonwood : > > Greetings, > > I'm getting an error compiling a parameter to a compiled statement. > Unfortunately, since I'm using a customer wrapper class around sqlite, > posting my code won't be much help. Here's what I'm doing: > > I create a compiled

[sqlite] Error Binding Parameter to Compiled Statement

Greetings, I'm getting an error compiling a parameter to a compiled statement. Unfortunately, since I'm using a customer wrapper class around sqlite, posting my code won't be much help. Here's what I'm doing: I create a compiled statement (two, actually). Then, each time through a loop, I bind

Re: [sqlite] Slim down join results (all fields returned)

On Fri, 17 Apr 2009, flakpit wrote: > Currently, I return any needed data like this. > > select * from pubs,notes,publishers where pub_title like '%salem%' > and pubs.note_id=notes.note_id > and pubs.publisher_id=publishers.publisher_id > > And it works except for all fields in the matching

Re: [sqlite] SQLITE_CANTOPEN error / bug?

Proposed fix: --- os_win.old 2009-04-09 20:41:18.0 +0200 +++ os_win.c2009-04-17 16:33:47.904710700 +0200 @@ -1317,7 +1317,7 @@ }else{ dwCreationDisposition = OPEN_EXISTING; } - if( flags & SQLITE_OPEN_MAIN_DB ){ + if( !(flags & SQLITE_OPEN_EXCLUSIVE) ){ dwShareMode

Re: [sqlite] Slim down join results (all fields returned)

> Currently, I return any needed data like this. > > select * from pubs,notes,publishers where pub_title like '%salem%' > and pubs.note_id=notes.note_id > and pubs.publisher_id=publishers.publisher_id > > And it works except for all fields in the matching tables being returned. > > Is

[sqlite] Slim down join results (all fields returned)

Currently, I return any needed data like this. select * from pubs,notes,publishers where pub_title like '%salem%' and pubs.note_id=notes.note_id and pubs.publisher_id=publishers.publisher_id And it works except for all fields in the matching tables being returned. Is there any way using

[sqlite] sqlite3_interrupt() can interrupt query started after it's return

Hi, I'm using sqlite as the sql driver of Qt 4. I have a connection created in a thread and i call sqlite3_interrupt() from another one. It's working great, perhaps i have not the behavior that say the doc : "A call to sqlite3_interrupt() has no effect on SQL statements that are started after

Re: [sqlite] SQLITE_CANTOPEN error / bug?

Hi again, the bug was introduced in revision 1.573 of pager.c. Best regards, Filip Navara On Fri, Apr 17, 2009 at 2:26 PM, Filip Navara wrote: > > Hello, > > today I tried to upgrade our software from SQLite version 3.6.3 to version > 3.6.13 and I am hitting a race

Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

> From: John Machin > Irrespective of what people tell you and how authoritative > they seem, I > would recommend that you do some simple tests: Excellent advice! Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite database to xml converter??

> From: candd > > Dear All! > > I am new user of sqlite3 > I want to have a sample C source for a program that convert > an sqlite > data base file to xml file. > could you help me please! Hi and welcome to the group. Your problem is very easy to solve, just rename your

[sqlite] SQLITE_CANTOPEN error / bug?

Hello, today I tried to upgrade our software from SQLite version 3.6.3 to version 3.6.13 and I am hitting a race condition that I believe is a bug in the library. The library is compiled as thread-safe (and it's reproducible even with the precompiled DLL). Sometimes sqlite3_step fails with

[sqlite] sqlite database to xml converter??

Dear All! I am new user of sqlite3 I want to have a sample C source for a program that convert an sqlite data base file to xml file. could you help me please! Many thanks! -- This mail was scanned by BitDefender