Re: [sqlite] [EXTERNAL] Non-keyword quoted identifiers parsed as string literals

2019-09-02 Thread William Chargin
> This is documented behaviour. Use single quotes for literal strings. > SQLite will assume you meant 'literlal' if your write "literal" and > there is no column of that name. There is no need to quote names in > SQLite unless the name contains non-alpha characters. Thanks, yes. I was quoting the

Re: [sqlite] [EXTERNAL] Non-keyword quoted identifiers parsed as string literals

2019-09-01 Thread Hick Gunter
This is documented behaviour. Use single quotes for literal strings. SQLite will assume you meant 'literlal' if your write "literal" and there is no column of that name. There is no need to quote names in SQLite unless the name contains non-alpha characters. -Ursprüngliche Nachricht- Vo