[sqlite] Bug Report - Analyzer app

Hi there, I use the sqlite3_analyzer.exe app get some data about tables (It's very useful by the way - thanks.) The newest version downloaded some days ago gave me import errors for the produced file, so I tried loading it manually, and then got the SQL which follows for one of my small DB

Re: [sqlite] Database gets locked for other processes

I know well the qt sqlite to say, maybe you aren't destroing the QSqlQuery class or simple call finish function, and the statement is openned helding the lock! Enviado via iPhone > Em 29/10/2013, às 10:51, Stephan Beal escreveu: > >> On Tue, Oct 29, 2013 at 1:52 PM,

[sqlite] Update and GROUP BY

All, I have this table: DROP TABLE T; CREATE TABLE T (N, V, G); INSERT INTO T VALUES('a', 1, 'x'); INSERT INTO T VALUES('b', 3, 'x'); INSERT INTO T VALUES('c', null, 'x'); INSERT INTO T VALUES('d', 80, 'y'); INSERT INTO T VALUES('e', null, 'y'); INSERT INTO T VALUES('f', 60, 'y'); INSERT INTO T

Re: [sqlite] Update and GROUP BY

On 11/2/2013 1:06 PM, Gert Van Assche wrote: All, I have this table: DROP TABLE T; CREATE TABLE T (N, V, G); INSERT INTO T VALUES('a', 1, 'x'); INSERT INTO T VALUES('b', 3, 'x'); INSERT INTO T VALUES('c', null, 'x'); INSERT INTO T VALUES('d', 80, 'y'); INSERT INTO T VALUES('e', null, 'y');

Re: [sqlite] Update and GROUP BY

Can you write a SELECT which returns the data that you want? Can you write a WHERE clause which selects the records you wish to update? For example: update T set V = (select avg(t2.g) from t as t2 where t2.g=t.g) where V IS NULL; assuming you only want to

Re: [sqlite] Update and GROUP BY

Igor, that is exactly what I need. I also understand how it is done now. Thanks! gert 2013/11/2 Igor Tandetnik > On 11/2/2013 1:06 PM, Gert Van Assche wrote: > >> All, I have this table: >> >> DROP TABLE T; >> CREATE TABLE T (N, V, G); >> INSERT INTO T VALUES('a', 1,

Re: [sqlite] Update and GROUP BY

Keith, thanks for this. The statement Igor made is what I need. gert 2013/11/2 Keith Medcalf > > Can you write a SELECT which returns the data that you want? > Can you write a WHERE clause which selects the records you wish to update? > > For example: > > update T >

Re: [sqlite] Update and GROUP BY

Good question Gert. Good solution, Igor and I like Keith's formatting. I thought the list might be interested in some of the statistical issues involved in determining if this method of replacing null values is an appropriate method for your data analysis and alternatives that are available. The

Re: [sqlite] possible join bug/regression with sqlite-3.8.1

On Mon, Oct 28, 2013 at 9:44 PM, Richard Hipp wrote: > The fix for this problem has been checked in: > > http://www.sqlite.org/src/info/9aac4e588c > > This problem was actually introduced in 3.8.0 but it was unreachable until > some additional enhancements were added in

Re: [sqlite] Second ORDER BY statement

On 11/2/2013 11:24 PM, SongbookDB wrote: I'm using the following query to first, display in asc order any records that have something in the language column, then any fields where the language column is an empty string (fyi I don't have nulls in this column). It works perfectly. I'd now like to

Re: [sqlite] Second ORDER BY statement

Not sure how if this is the way to reply, but thank you Igor. On Sun, Nov 3, 2013 at 3:16 PM, Igor Tandetnik wrote: > On 11/2/2013 11:24 PM, SongbookDB wrote: > >> I'm using the following query to first, display in asc order any records >> that have something in the