Re: [sqlite] Table info for a particular query

2011-06-09 Thread Nuno Lucas
> Is there any way to do something along the lines of PRAGMA > some_command(SELECT * FROM table1 JOIN table2) and have it return A, B, C, > a, b, c as the headers? If you really want to do it with "table_info", you could create a temporary view with the "select":

Re: [sqlite] Is additional Check Constraint info available?

2011-06-09 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/09/2011 10:57 AM, Noah Hart wrote: > there any way to tell which of the constraint would have been violated? No. Long known issue (since January 2006) with uninformative constraint failure messages:

Re: [sqlite] Dynamically loaded sqlite (linux)

2011-06-09 Thread Max Vlasov
On Thu, Jun 9, 2011 at 6:21 PM, Pavel Ivanov wrote: > > > So if you ever want to use dlopen() you should be really really > careful to avoid loading the same library several times (even if the > same library have different file names). > > Pavel, thanks for the hint and the

Re: [sqlite] [sqlite-dev] Index problem on Windows

2011-06-09 Thread Pavel Ivanov
> So my next question is then, given that I have some data coming in, in > a random order, and I want an index. What can I do in order for the > performance to be better? Create index only after all data is populated. BTW, this kind of questions will be answered best on a sqlite-users list.

[sqlite] Is additional Check Constraint info available?

2011-06-09 Thread Noah Hart
Assume that a table has several check restraints, such as a unique index and a foreign key. When inserting a row that violates more than one of the constraints, is there any way to tell which of the constraint would have been violated? Thanks, Noah Hart -- View this message in context:

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Christoph P.U. Kukulies
Am 09.06.2011 16:01, schrieb Paul Linehan: >> Thanks. I was prepared to receive alternate suggestions :) >> I wanted to have hands on and control over a browser with which >> can follow sqlite versions quicker. > > If you want something that works on Linux as well as Windows, try > the Firefox

Re: [sqlite] Dynamically loaded sqlite (linux)

2011-06-09 Thread Pavel Ivanov
> I know that I should avoid such things, but just curious, is it something > inside sqlite that probably makes one dynanmically linked and other > dynamically loaded library share global data and can this be avoidable? No, it's Linux linker who works like that. If you have several libraries

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Paul Linehan
> Thanks. I was prepared to receive alternate suggestions :) > I wanted to have hands on and control over a browser with which > can follow sqlite versions quicker. If you want something that works on Linux as well as Windows, try the Firefox SQLite extension - it's the dog's! Rgs, Paul...

Re: [sqlite] Dynamically loaded sqlite (linux)

2011-06-09 Thread Max Vlasov
On Tue, Jun 7, 2011 at 9:22 PM, Martin Gadbois wrote: > On Tue, Jun 7, 2011 at 12:52 PM, Jay A. Kreibich wrote: > > > On Tue, Jun 07, 2011 at 07:47:25PM +0400, Max Vlasov scratched on the > wall: > > > Hi, > > > > > > I'm trying to use sqlite with linux

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Oliver Peters
Christoph P.U. Kukulies writes: [...] > > Thanks. I was prepared to receive alternate suggestions :) > I wanted to have hands on and control over a browser with which > can follow sqlite versions quicker. > > Sqlitebrowsers tend to lag behind the Sqlite development. > > Is the one

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Jean-Christophe Deschamps
>Thanks. I was prepared to receive alternate suggestions :) >I wanted to have hands on and control over a browser with which >can follow sqlite versions quicker. > >Sqlitebrowsers tend to lag behind the Sqlite development. Then give SQLite Expert a try! http://www.sqliteexpert.com/

[sqlite] Bug: ERROR_DISK_FULL is not handled in Win32 OS layer

2011-06-09 Thread Filip Navara
Hi, the Win32 OS layer function winWrite checks for the ERROR_HANDLE_DISK_FULL error code to detect "disk full" condition: if( pFile->lastErrno==ERROR_HANDLE_DISK_FULL ){ This check is not sufficient since the error code could also be ERROR_DISK_FULL. See [1] for description of the error.

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Christoph P.U. Kukulies
Am 09.06.2011 11:12, schrieb Oliver Peters: > Christoph P.U. Kukulies writes: > >> I tried sqlitebrowser 2.0 b1.exe from Sourceforge (the Windows binary) >> on some newer >> sqlite databases 3.7 or sth. and it could not open it. >> > [...] > > If you don't insist to use sqlitebrowser I

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Oliver Peters
Christoph P.U. Kukulies writes: > > I tried sqlitebrowser 2.0 b1.exe from Sourceforge (the Windows binary) > on some newer > sqlite databases 3.7 or sth. and it could not open it. > [...] If you don't insist to use sqlitebrowser I can recommend sqlitespy

[sqlite] sqlitebrowser - anyone compiled a recent one?

2011-06-09 Thread Christoph P.U. Kukulies
I tried sqlitebrowser 2.0 b1.exe from Sourceforge (the Windows binary) on some newer sqlite databases 3.7 or sth. and it could not open it. So I went out and tried to compile the checked out sources (using VS2008 and Qt 4.7). Somewhere, when uic3.exe is being called, the nmake fails with wrong