Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Error in generated sql

rbuserrbuser
edited March 2004 in End User
One of my users has created a query in the report designer containing an
"OR" search criterium like the following:

begin
criterium1
OR
criterium2
end

both criterium1 and criterium2 have the properties 'Autosearch' and 'Show
all' set to true, and have no default value set. The problem is that the
report designer creates an erroneous sql statement for those criteria.

The sql contains an 'AND ()' (notice the empty parentheses) which causes
an SQL error, while there shouldn't be an 'AND' at all, since no value is
specified for those criteria.

I am using Reportbuilder 7 enterprise and ORACLE 8.1.7 as db.

Is this a bug or am I missing something?

Thanks for your help,

Luc Feys

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

Comments

  • nicociziknicocizik
    edited March 2004
    Hi Luc,

    This looks to be a limitation of the QueryDesigner. When using AutoSearch
    with either blank AutoSearchFields or ShowAll set to True, you cannot
    enclose the criteria inside parentheses. I will mark this down to be fixed
    in a future release of ReportBuilder. Thanks,

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.