Subject [IBO] V4.7.16 enhancement plea
Author Paul Hope
( 'Brackets' english = 'Braces' US) ;-)

A while back the problem came to light that the use of '('s in join caused
unpredictable results in the latest version.
eg ((a join b on blabla) left join c on bladebla)

I accepted that the brackets are completely useless and shouldn't be there
and couldn't recall where I got the idea of using them in the first place.

I searched my app for variations of 'from ((' and ')left' and ')join' to try
and remove them all.

Since then one has fallen through the cracks and caused a customer to print
40,000 pages of a 10 page report. Also some posts on the FirebirdSQL forum
have shown that other people have used brackets in joins.

My plea therefore is to have IBO throw out an invalid join syntax error
rather than carry on with unpredictabe results ;-)


[Non-text portions of this message have been removed]