autosearch matching field value error

rbuser

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

rbuser

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

nicocizik

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

rbuser

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

nicocizik

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