[sqlite] 3.23 Windows x64 dll

Is there no 64 bit precompiled dll available for Windows with this release? David Raymond | GIS Engineer | TomTom | Lebanon, NH, United States e-mail: david.raym...@tomtom.com | office +1 603 306 8498 | www.tomtom.com

Re: [sqlite] 3.23 Windows x64 dll

> Le 2 avr. 2018 à 16:48, David Raymond a écrit : > > Is there no 64 bit precompiled dll available for Windows with this release? It looks like it is available: https://www.sqlite.org/download.html -- Best Regards, Meilleures salutations, Met vriendelijke groeten,

Re: [sqlite] sqlite3_column_decltype and affinity

I understand the type can differ between rows, but that's also the case for a regular table, and https://www.sqlite.org/datatype3.html#affinity_of_expressions says << An expression of the form "CAST(expr AS type)" has an affinity that is the same as a column with a declared type of "type". >>

Re: [sqlite] Before Insert/Update Trigger

Hi Thomas. Below is a toy "records" table example which illustrates the INSTEAD OF pattern. --- CREATE TABLE records(rowid INTEGER PRIMARY KEY, data INTEGER, change_date TEXT DEFAULT CURRENT_TIMESTAMP); CREATE VIEW instead_of_records AS SELECT * FROM records; CREATE TRIGGER