Autosearch for data with leading spaces

rbuser

Is it possible to use autosearch for data that may or may not have a
leading space? Due to sorting needs of mixed numeric/alpha names, the
database has names that may contain 0, 1, 2, or 3 leading spaces. Data
examples: " 12Y", "1234", " 123".

Unfortunately as an end user solution we do not have the opportunity to
strip the spaces in the database. I have tried entering the spaces in
the autosearch dialog with or without quotes, and tried wild card
characters in the dialog. Also tried a little to strip spaces in the
data itself before the autosearch really runs, like in
BeforeAutoSearchCreate". It would help if the user could do this in the
Autosearch list or in the single entry.

Thanks,
Scott Stalheim

nicocizik

Hi Scott,

ReportBuilder (DADE) will strip all leading spaces from a search
criteria value before sending the SQL query to your database. You can
see where this is done in the daSQL.pas file of our source
(ResolveCriteria routine).

In your case, you would likely need to create a temporary table that
removes leading spaces. Another option, although not recommended or
supported, is to alter the source.

We will consider adding a property to control this behavior for a later
release.