Re: [sqlite] Problem with CASE in WHERE clause

2016-12-03 Thread Frank Millman
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 >

Re: [sqlite] Problem with CASE in WHERE clause

2016-12-03 Thread Simon Slavin
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.

[sqlite] Problem with CASE in WHERE clause

2016-12-03 Thread Frank Millman
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

Re: [sqlite] Datatype for prices (1,500)

2016-12-03 Thread Barry Smith
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

Re: [sqlite] Searching sqlite3dll for WinCE 5.2 aka Windows Embedded Handheld 6.5 Classic

2016-12-03 Thread Simon Slavin
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

[sqlite] Searching sqlite3dll for WinCE 5.2 aka Windows Embedded Handheld 6.5 Classic

2016-12-03 Thread Ertan Küçükoğlu
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

Re: [sqlite] Datatype for prices (1,500)

2016-12-03 Thread Keith Medcalf
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