Re: [Jprogramming] Issue with qualified column name in SQLite query

2022-03-24 Thread Raul Miller
Note that there's still an issue. Quoting in sql is a mechanism which removes the special significance of certain characters, allowing them to be used in column names. And, the data/sqlite 'fixselect__db' mechanism is based on an assumption that '.' was intended to be used in the name of a column

Re: [Jprogramming] Issue with qualified column name in SQLite query

2022-03-24 Thread bill lam
There was a bug in sqlite.ijs now fixed. Please get update and test again. Thank you for the detail report. On Thu, Mar 24, 2022 at 4:08 PM Ulrich Vollert wrote: > Hi, > > I noticed an issue with SQLite and qualified column names - working with > j903/j64/darwin and data/sqlite 1.0.35. > > When

[Jprogramming] Issue with qualified column name in SQLite query

2022-03-24 Thread Ulrich Vollert
Hi, I noticed an issue with SQLite and qualified column names - working with j903/j64/darwin and data/sqlite 1.0.35. When I use two table names in a join as shown below, and the first column name after the SELECT is qualified, I get no reply?? When the qualified name is the second column in th