[sqlite] Problem with accumulating decimal values

On Thu, 17 Dec 2015 13:13:24 Simon wrote: >to round only when you need to be handling integers. Round the result to maximum two digits after the decimal point (or comma) when it handles about money. Kind regards |?Cordiali saluti | Vriendelijke groeten | Freundliche Gr?sse, Klaas `Z4us` V ?-

[sqlite] {Spam?} SQLite take lower performance while using shared cache on iOS/Mac

17 dec 2015, sanhua.zh: > I try to use shared cache to optimize my code. > Sincesqlite3_enable_shared_cache is deprecated on iOS/Mac, I > usesqlite3_open_v2 withSQLITE_OPEN_SHAREDCACHE flag to open shared > cache mode. > 4 threads select is running in my code, while each thread has its >

[sqlite] maybe bug in regexp and replace with newlines?

>/> The statement: />/> select distinct text from v_term_item where replace(lower(text),0x0A,'') REGEXP('.*/some_text/.*'); />/> doesn't work like that: / > Try x'0A' instead (that's a BLOB literal, and should be converted to a > string). 0x0A is an integer, I suspect it gets converted to the

[sqlite] Problem with accumulating decimal values

On 18 Dec 2015 at 00:06, Keith Medcalf wrote: >> I was taught "Round [only] before printing.". These days it would be >> something like "Round [only] before your API returns to the calling >> program. > > Those are not the same. Round only before printing (whether to the screen or > to a

[sqlite] No Sqlite.dll for VS 2015 C# console application

Hello, I have a Universal app with SQLite using sqlite-net and referencing SQLite for Universal App Platform that works. I am using VS 2015 update 1, Windows 10. I am trying to make a console application using sqlite-net but I cannot find a valid reference to SQLite. I have installed SQLite for

[sqlite] No Sqlite.dll for VS 2015 C# console application

you'll need system.data.sqlite.dll not just sqlite3.dll. I prefer to use the static version so system.data.sqlite.dll contains the sqlite3.lib so it's standalone other than the runtime used. (I've sometimes had to copy msvc*d.dll (debug version) because I'm sometimes lazy and know that it has

[sqlite] No Sqlite.dll for VS 2015 C# console application

Is System.Data.SQLite.dll in your bin folder along with the x86, x64 folders and corresponding SQLite.Interop.dll files? -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: