Impossible database error

General
43

If it is SQLite, then quotes really only matter if the values are NOT numeric
meaning

Set xyz=3
Set xyz='3'

both work the same for SQLite (not necessarily for other Databases)… This is because unlike most other database engines, SQLite really doesn’t have “datatypes”… it has what are known as “affinity”… making it very loose in this respect.

44

That’s interesting Dave. I tried quoting the numbers and still got the error.

45

Yep, it was an impossible error . . . . It was an error in a completely different statement.

46

Doh!

Glad you got to the bottom of it :slight_smile: