Re: [sqlite] Either a bug or I don't understand SQL update

2020-01-30 Thread David Raymond
ck Sent: Wednesday, January 29, 2020 6:11 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Either a bug or I don't understand SQL update I've been using sqlite for some time but haven't used SQL update until recently. On my first real use, I've encountered a problem that I can't underst

Re: [sqlite] Either a bug or I don't understand SQL update

2020-01-30 Thread Igor Tandetnik
"M" refers to a column named M, specifically, citytax.m . Similarly, "G" is a reference to citytax.g. String literals in SQL are enclosed in single quotes, as in 'M' and 'G' ; double quotes are used to enclose names (helpful for names that contain spaces or other characters not allowed in

[sqlite] Either a bug or I don't understand SQL update

2020-01-30 Thread Paul Ausbeck
I've been using sqlite for some time but haven't used SQL update until recently. On my first real use, I've encountered a problem that I can't understand at all. To pare this down, I have two tables, citytax and taxitems2, and I've attached a database with just these two tables, total size