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

autosearch matching field value error

edited August 2009 in DADE
Hi,
I am using RB 7.04 and when an Autosearch value is entered, the
correct record in my Paradox database is accessed, EXCEPT when the value
begins with a space (as must be the case for some entries in this
database, unfortunately).
So if the user has "Smith" in the database that is fine, but if it is
" Smith", then no entry technique seems to work for the end-user (there
are no quote marks in the database). IOW the user can try entering the
leading space in the Autosearch dialog, surround his entry with quote
marks, etc. but no match can be established unless we go and remove the
leading space in the underlying database. Must be a work-around?

TIA,
Scott

Comments

  • edited August 2009
    In sql exists un underscore as a joker for one char. Perhaps it helps to
    search _Smith.


    --
    Chris (Eulanda)
    http://www.eulanda.de
    International ERP Solutions



  • edited August 2009
    Hi Scott,

    By definition, ReportBuilder will trim all leading spaces off any search
    condition. There currently is no workaround however we will consider adding
    an option to DADE for a later release. Currently and for your version, you
    can see where the value is trimmed in the daSQL.pas file. Inside the
    TdaSQL.ResolveCriteria routine there is a sub-routine named FormatValue.
    The first line of this routine trims the value. Changing this should solve
    the problem.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2009
    Nico Cizik (Digital Metaphors) wrote:
    Thanks, I found and changed the code line as you described, but
    apparently I need to know the basic procedure to re-compile the runtime
    package in Delphi 7.

    Scott
  • edited September 2009
    Hi Scott,

    As you try and rebuild the runtime packages, Delphi should let you know
    which packages need to be recompiled in addition. Start with the rbDAD
    package where the daSQL.pas file is defined. You may be directed to
    recompile some of the RB packages such as rbRCL as well.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

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