From: Simon Slavin
Sent: Sunday, December 04, 2016 8:42 AM
To: SQLite mailing list
Subject: Re: [sqlite] Problem with CASE in WHERE clause
On 4 Dec 2016, at 8:42am, Simon Slavin slav...@bigfraud.org wrote:
> What are we allowed to change ? Are you asking us to find a "SELECT" command
>
On 4 Dec 2016, at 5:33am, Frank Millman wrote:
> I really need this to work
What are we allowed to change ? Are you asking us to find a "SELECT" command
which works both in SQLite and PostgreSQL ? Can we change the table definition
too ?
Simon.
Hi all
I have a problem using a CASE statement in a WHERE clause.
On testing a column which contains a ‘1’, WHERE returns true if I test for 1
(without the quotes), but false if I test for ‘1’ (with quotes).
CREATE TABLE test_1 (tran_type TEXT, amount INTEGER, posted BOOL)
INSERT INTO test_1
Nice.
Say goodbye to transitive equality though.
> On 3 Dec 2016, at 5:02 AM, Keith Medcalf wrote:
>
>
> feq (and friends) are an extension I wrote that does proper floating point
> comparisons:
>
> /*
> ** 2015-11-09
> **
> ** The author disclaims copyright to this
On 3 Dec 2016, at 12:33pm, Ertan Küçükoğlu wrote:
> Now, I have to distribute same application on Windows Embedded Systems. But;
> 1) CE OS 5.2.29354 device: Intermec CK3R, runs fine for first time after a
> device boot and then gives me error saying "Can not load
Hello,
I have an application developed with Lazarus. I already have a sqlite3.dll
v3.9.2 for CE which works just fine under OS "Microsoft Windows CE Version
6.0" for several years.
Now, I have to distribute same application on Windows Embedded Systems. But;
1) CE OS 5.2.29354 device: Intermec
feq (and friends) are an extension I wrote that does proper floating point
comparisons:
/*
** 2015-11-09
**
** The author disclaims copyright to this source code. In place of
** a legal notice, here is a blessing:
**
**May you do good and not evil.
**May you find forgiveness for
7 matches
Mail list logo