Query Designer SQL not same as Search Criteria

rbuser

RB 7.03, Delphi 7 Enterprise

To whom it may concern.

Please view the attached images for the problem I reported in version 6.x.
The SQL does not properly represent the search criteria.

I was assured that version 7.x would fix this and paid for the upgrade.

The other problem is that when you preview the report and then hit the
Search button to launch the search dialog, even if we have used "LIKE" it
says "begin with". And if using "OR" it still says "and" in the search
dialog.

The above problems are annoying when trying to provide end-user solutions.

Can these be fixed ASAP please.

Best regards

Michael Lekias
PSD
www.psdesign.com.au

nardmoseley

For future reference please do not post attachments/images etc to the
newsgroups. Send them to support@digital-metaphors.com.

You are encountering some limitations of the current implementation. These
are known limitations with ReportBuilder 7. I am sorry if I or someone else
at Digital Metaphors misunderstood and advised you otherwise. We offer a
30-day money back guarantee on purchases.

1. The Like operator is often used to perform searches such as 'B%' . When
you use the Like operator the default AutoSearch dialog displays 'begins
with' to be more user friendly. This is by design.

2. The default AutoSearch dialog does not know whether And or Or was used.
It always displays andAnd.

The built-in AutoSearch dialog can be replaced. For an example see
RBuilder\Demos\AutoSearch\Custom AutoSearch dialog.

3. When the Begin/End parentheses are used and no criteri are entered you
end up with the ( ) in the SQL Where clause. As a work around you might try
specifying one of the criteria as mandatory.




--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com