Re: [sqlite] New kids on block the SQLite Master Suite.

Hi Dave, Thank you for info. I'm aware of this. in fact, you could built an app that run all version of Windows with vs2012 but you have to install vs2008, vs2010, then vs2012. Since acquiring license from microsoft with older version of visual studio is expensive. We just don't want to do it

Re: [sqlite] New kids on block the SQLite Master Suite.

Hi Keith, We actually have a version that run from windows 2000 and up but we don't have older Visual studio license so we could not release it. We will work on this issue soon. Billy From: sqlite-users-boun...@sqlite.org

Re: [sqlite] New kids on block the SQLite Master Suite.

Billy, If it was built to run on XP Level API's then it should run on any version or Windows from XP up with no problem. It is even conceivable that it will run on Windows 2000 SP4 (there were very few API changes between 2000 (0x0500) through Windows 2003 (0x0502) -- for example, the 2003

Re: [sqlite] New kids on block the SQLite Master Suite.

FYI, you can support XP when building with VS2012 if you have VS2012 SP3 installed (which you probably do if you've installed current stuff), and set the 'platform toolset' (under project properties, configuration properties, general) to 'v110_xp' (I don't have it in front of me, this is from

Re: [sqlite] New kids on block the SQLite Master Suite.

Hi Simon, Your suggestions are invaluable. In fact, I'm going to change things around with your inputs soon. Thank you very much. Best regards, Billy From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin

Re: [sqlite] New kids on block the SQLite Master Suite.

Hi Jonathon, Thank you for your feedback. It supposed to work on any Windows version from XP and up. SMS was built with VS2012 and VS2012 on supports from XP and up. Best regards, B. Huynh From: sqlite-users-boun...@sqlite.org

Re: [sqlite] New kids on block the SQLite Master Suite.

Hi Keith, Thank you for your feedback. The SQLite Master Suite source codes are very primitive. In theory, it can be compiled with the earlier compiler and run at all Windows OS. However, we've built the SQLite Master Suite with Visual Studio 2012 and VS2012 has stopped supporting any OS older

Re: [sqlite] New kids on block the SQLite Master Suite.

Microsoft takes special care in bug-for-bug compatibility, so win32 programs are pretty much guaranteed to run on any version of the OS that is equal or greater than the WINVER setting on which it was compiled. If it runs on W2K3 then it was compiled with WINVER set to 0x0502 (but perhaps was

Re: [sqlite] v3.4.0 of DB Browser for SQLite released

On 2014-10-29 23:45, jus...@postgresql.org wrote: Hi everyone, We've (finally) released version 3.4.0 of DB Browser for SQLite. This is the cross platform GUI application that was known for many years as "SQLite Database Browser" before the recent rename. Downloads for Windows and OSX here:

Re: [sqlite] New kids on block the SQLite Master Suite.

On Thursday, October 30, 2014 12:16:17 AM jonathon wrote: > On 29/10/14 19:46, Billy Huynh wrote: > > the SQLite Master Suite. > > It mainly designed to handle a very large database file with lightning > > fast import and export of data and > Support for Windows Server 2003, which EOLs on Bastille

Re: [sqlite] New kids on block the SQLite Master Suite.

On 29/10/14 19:46, Billy Huynh wrote: > the SQLite Master Suite. > It mainly designed to handle a very large database file with lightning fast > import and export of data and Support for Windows Server 2003, which EOLs on Bastille Day 2015, but no support for Windows Server 2012? If that

Re: [sqlite] Index usage for order by and where clauses

On Wednesday, 29 October, 2014 07:47, Clemens Ladisch said: >Baruch Burstein wrote: >> If I have an index on table1(colA, colB), will it be used for both the >> where and the order by in either of these cases: >> select * from table1 where colA=1 order by colB; >> select * from table1 where

[sqlite] v3.4.0 of DB Browser for SQLite released

Hi everyone, We've (finally) released version 3.4.0 of DB Browser for SQLite. This is the cross platform GUI application that was known for many years as "SQLite Database Browser" before the recent rename. Downloads for Windows and OSX here:

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

On 10/29/2014 5:42 PM, Baruch Burstein wrote: SELECT max(a), b FROM t WHERE a<50; Is there some way to filter *after* this is applied? Wrap it in another select: select * from ( SELECT max(a) maxa, b FROM t WHERE a<50 ) where b is not null; -- Igor Tandetnik

Re: [sqlite] New kids on block the SQLite Master Suite.

On 29 Oct 2014, at 7:46pm, Billy Huynh wrote: > Please check it out by visiting http://www.aimtelligentsw.com? A few quick tips: * Say right up front which operating systems your application runs on. * What's Windows 2003 ? * On the download page, explain what

[sqlite] New kids on block the SQLite Master Suite.

Hi every one, After years hard at work, Aimtelligent Software has produced its first product, the SQLite Master Suite. We proudly present this product to the public for we think that it will be adapted widely by SQLite 3 users. Performance and simplicity are the core features of this product.

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

On Wed, Oct 29, 2014 at 8:43 PM, Richard Hipp wrote: > > If I have a table, "t", with 2 columns, "a" and "b". Assuming that "a" > is a > > unique number, will the following query always return the whole row (that > > is, with the correct "b" column) where "a" is the highest

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

On Wed, 29 Oct 2014 20:38:07 +0200 Baruch Burstein wrote: > If I have a table, "t", with 2 columns, "a" and "b". Assuming that > "a" is a unique number, will the following query always return the > whole row (that is, with the correct "b" column) where "a" is the > highest

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

On Wed, Oct 29, 2014 at 4:28 PM, Staffan Tylen wrote: > But if several rows have the same a value as the max value then the b value > will be arbitrary, or? > Then b will be from one of the rows for which a is maximal - but you don't know which one. Similarly, if you

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

But if several rows have the same a value as the max value then the b value will be arbitrary, or? Staffan On Wed, Oct 29, 2014 at 7:43 PM, Richard Hipp wrote: > On Wed, Oct 29, 2014 at 2:38 PM, Baruch Burstein > wrote: > > > Hi, > > > > If I have a

Re: [sqlite] Database is locked exceptions

On 2014-10-29, 12:13 PM, Mike McWhinney wrote: System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

On Wed, Oct 29, 2014 at 2:38 PM, Baruch Burstein wrote: > Hi, > > If I have a table, "t", with 2 columns, "a" and "b". Assuming that "a" is a > unique number, will the following query always return the whole row (that > is, with the correct "b" column) where "a" is the

[sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

Hi, If I have a table, "t", with 2 columns, "a" and "b". Assuming that "a" is a unique number, will the following query always return the whole row (that is, with the correct "b" column) where "a" is the highest number below 50? SELECT max(a), b FROM t WHERE a<50; -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ

Re: [sqlite] Database is locked exceptions

On 29 Oct 2014, at 4:13pm, Mike McWhinney wrote: > "URI=file:mydb.db; default timeout=10; Pooling=True; Max Pool Size=100;"; Can you please change your timeout to 1 (really, 1ms == 10 seconds) and see if this makes the problems go away ? It may not be necessary

[sqlite] Database is locked exceptions

Hello, I have written a program in C# Visual Studio Winforms. In general the SQLite database is working quite well. However, lately we have been plagued with database locking errors: Here is the exeption: database is locked database is locked at

Re: [sqlite] sqlite3.c in a library - api rename

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/28/2014 08:18 PM, Ward Willats wrote: > I am using the amalgamation in a C++ library statically linked into > other people's applications. > > Is there a way to namespace and/or macro and/or let C++ do its > name-mangling thing to all the

Re: [sqlite] Index usage for order by and where clauses

Baruch Burstein wrote: > If I have an index on table1(colA, colB), will it be used for both the > where and the order by in either of these cases: > > select * from table1 where colA=1 order by colB; > select * from table1 where colB=1 order by colA; $ sqlite3 sqlite> create table table1(colA,

[sqlite] Index usage for order by and where clauses

Hi, If I have an index on table1(colA, colB), will it be used for both the where and the order by in either of these cases: select * from table1 where colA=1 order by colB; select * from table1 where colB=1 order by colA; -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı

Re: [sqlite] inserted row isn't deleted after rollback?

On Wed, Oct 29, 2014 at 6:35 AM, d...@gmx.com wrote: > Hello! > > I have met the situation, which looks like sqlit3 bug. The full script > can be found at [1]. To reproduce it, I just type: > > sqlite3 -batch /tmp/db-2.tmp < /tmp/x.sql > > Where /tmp/x.sql is the saved to disk

[sqlite] inserted row isn't deleted after rollback?

Hello! I have met the situation, which looks like sqlit3 bug. The full script can be found at [1]. To reproduce it, I just type: sqlite3 -batch /tmp/db-2.tmp < /tmp/x.sql Where /tmp/x.sql is the saved to disk script [1]. So, the essential problem lies in the last lines: PRAGMA

Re: [sqlite] problem trigger

thanks Simon, I´ll try later and then I´ll tell you 2014-10-28 17:11 GMT-03:00 Simon Slavin : > > On 28 Oct 2014, at 8:06pm, pablo Van wrote: > > > WHEN new.DiaHs_Inicio not between (old.DiaHs_Inicio and old.DiaHs_Fin) > > I do not think SQLite supports