Re: [sqlite] Updating multiple records in C#

> On Dec 6, 2016, at 5:40 PM, Richard Andersen wrote: > > cmd.CommandText = @"UPDATE pdata SET FileName = @fileName WHERE FileName = > 'filename.zip'"; You can add other columns to set by adding more “name = value” expressions in between SET and WHERE. Here’s the

[sqlite] Updating multiple records in C#

I have a table with several thousand records each with multiple fields. One field contains a filename, this is the only unique field so I use it to identify the different records. What I need is a way to update all fields that have changed in any record, at once. There's no need to check IF a

Re: [sqlite] About a potential error in sqlite3.c

On 12/5/16, Zhendong Wu wrote: > > If NULL is passed to the second parameter of function ‘sqlite3PagerOpenWal’, > LINE 53683 will dereference a NULL pointer and cause a Segmentation fault. The two lines at https://www.sqlite.org/src/artifact/4e4aea7c?ln=7314-7316 guaranteed

[sqlite] SQLite 3.11+ broken on EBCDIC systems (includes patch)

SQLite has built-in support for EBCDIC-based systems, but I discovered that it’s been broken since 3.11.0. In particular, in February 2016, several changes were made to the SQL tokenizer for performance to use a character lookup table instead of a switch statement based on character literals

[sqlite] About a potential error in sqlite3.c

Hi, I have downloaded the source code of SQLite Version 3.15.2 which is a big file called sqlite3.c. I statically analyzed the code and found a potential error. Could you please check the correctness? Thank you. In file ‘sqlite3.c’, function ‘sqlite3PagerOpenWal’, the piece of code is shown

Re: [sqlite] Problem with CASE in WHERE clause

On 6 Dec 2016, at 3:36pm, David Raymond wrote: > It seems that the CASE expression results in NO AFFINITY as an expression, > and does not carry the affinity of "posted" even though it is a direct > reference to the field. Therefore the first bullet point in section

Re: [sqlite] Problem with CASE in WHERE clause

http://www.sqlite.org/datatype3.html section 3+ When you declare a field as type "bool" it gets assigned NUMERIC type affinity. "A column with NUMERIC affinity may contain values using all five storage classes. When text data is inserted into a NUMERIC column, the storage class of the text is