vue 2.62: Custom Views: SQL broken - space before JOIN missing

February 22, 2019, 02:03:04 PM

Hi,

I notice, that creating a table with query builder for the custom views, that when I use two tables the empty space before JOIN is missing. As a result, the SQL is broken.
Example:

Code: [Select]

SELECT  m.loginname FROM taetigkeit AS tJOIN mitarbeiter AS m ON t.atze_id=m.atze_id ORDER BY m.loginname ASC

should be

Code: [Select]

SELECT  m.loginname FROM taetigkeit AS t JOIN mitarbeiter AS m ON t.atze_id=m.atze_id ORDER BY m.loginname ASC

Olaf

Re: vue 2.62: Custom Views: SQL broken - space before JOIN missing

Reply #1 – February 22, 2019, 02:28:40 PM

Thanks for this information.