Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Autosearch for data with leading spaces

edited April 2016 in End User
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

Comments

  • edited April 2016
    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.

    Best Regards,

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