Hi,
I got a DBQuery with a JOIN and ORDER statement. I do not write the query manually, I just add the two tables and set the SORT property for one of my columns, and define a CLOUD_CONNECTOR, everything using the Query Builder. I left the default "Inner (traditional)" join type.
The generated SQL code seems correct in the Query Builder, and it runs when I use the "Execute" button in the Query Builder(I must provide a value for the cloud connector parameter, of course).
But at runtime, the SQL sentence is somehow scrambled and causes a runtime error because incorrect SQL syntax.
The general structure of the runtime query:
------
SELECT [ columns ] FROM table1,table2
WHERE [ cloud connector condition ]
ORDER BY [ my sort column ]
[ join condition ]
-------
If I use the Query Designer to change the link join type from "inner (traditional)" to "inner join"
------
SELECT [ columns ] FROM table1 INNER JOIN table2 ON [ join condition ]
WHERE [ cloud connector condition ]
ORDER BY [ my sort column ]
-------
And works ok both at the designer and at runtime. Obviosly the join condition is moved to the ON statement and not added at the end of the query after the ORDER BY, and I'm using this a a workaround for now.
Regards
We'll fix it. Thanks for reporting.