Reportbuilder 20 Firebird 1.5 problem - Clause ROWS
Hi, When I creating query in query builder, mistake occurs after post "..... Token unknow line 6, char 1 ROWS"
Word "ROWS" is not visible at tab sql text. I konw, Firebird 1.5 unknows clause Rows, but the word should not be there.
In RB 19 is all fine.
Please where is problem ? Thank
Word "ROWS" is not visible at tab sql text. I konw, Firebird 1.5 unknows clause Rows, but the word should not be there.
In RB 19 is all fine.
Please where is problem ? Thank
Comments
RB SQL validation uses Row Limit to optimize where supported. I emailed specifics on disabling this for Firebird, it requires modifying the source code.
Going forward best solution is to upgrade to latest Firebird.
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
I must try it