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 at
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 on
behalf of Keith Medcalf
Sen
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 AP
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
mem
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
Sent: Wednesday, October 29, 2014 6:30
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 on
behalf of jonathon
Sent:
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 t
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
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:
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
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 real
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 colB=
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:
https://github.com/sqlitebrowser/sqlitebrowser/rel
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
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 can be done with the 'Trial vers
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. I
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 number below
> 50?
> >
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 number below 50?
>
> S
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 say:
SELECT max(a), ma
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 table, "t", with 2 columns, "a" and "b". As
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 System.Windows.Forms.UnsafeNativeMethods.DispatchMessag
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 highest number below 50?
>
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ɯ ɹno
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 to leave the setting li
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 System.Data.SQLite.SQLite3.Step(SQLiteStateme
-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 identi
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, col
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ʎ ɟı
___
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 script [1].
>
> So,
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 foreign_keys=ON
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 NOT BETWEEN. I would change it to
> somet
31 matches
Mail list logo