Re: [sqlite] invalid date time

On Sun, Feb 18, 2018 at 10:02 PM, Olivier Leprêtre wrote: > Hi, > > > > I have an sqlite database with wrong information in a timestamp field. > Using > System.Data.Sqlite, I want to get this information as a string inside a > very > simple loop. > > > > while (i <

[sqlite] invalid date time

Hi, I have an sqlite database with wrong information in a timestamp field. Using System.Data.Sqlite, I want to get this information as a string inside a very simple loop. while (i < reader.FieldCount) { txt = reader[i].ToString(); // or reader.GetString(i) or

Re: [sqlite] Recommended tool to read SQLITE btree?

On 17 February 2018 at 08:34, Deon Brewis wrote: > Anybody have a recommendation for a tool that can read/show/interpret a > SQLITE file at the BTREE level? > > Want to be able to decode the links between pages, figure out what all the > data mean etc. And should be able to work

[sqlite] Test error in oserror-2.1.1

Hello, I've tried to run the quicktest suite for SQLite 3.22.0 on Linux (kernel version 4.13.0), and when it executes test/oserror.test I get errors: oserror-1.1.1... Ok oserror-1.1.2... Ok oserror-1.1.3... Ok oserror-1.2.1... Ok oserror-1.2.2... Ok oserror-1.3.1... Ok oserror-1.3.2... Ok

Re: [sqlite] Using bind_text for numeric columns

Thanks Simon. I’ve not encountered any problems so far but I would’ve preferred a sqlite3_value solution so I could be sure. At the moment I’m messing about with a ‘dummy’ query ‘select ?1, ?2, .,?n’ and binding the results I need from the first query to the dummy one using bind_value.

Re: [sqlite] Using bind_text for numeric columns

On 18 Feb 2018, at 12:44pm, x wrote: > Suppose I have a query with several parameters on columns that could be > integer, real or text. The values for these parameters are taken from the > result set of another query which is stored in a string array. > > Is there any

[sqlite] Using bind_text for numeric columns

Suppose I have a query with several parameters on columns that could be integer, real or text. The values for these parameters are taken from the result set of another query which is stored in a string array. Is there any pitfalls or disadvantages to binding them all as text as opposed to the