Spaces in Search Criteria Value

rbuser

Hi,

How kan i prevent removing of (leading) spaces from the search value:

lField.SearchExpression:= ' 200';
SQL.AddCriteriaField(lTable, lField.FieldName, dacoEqual,
lField.SearchExpression);

results in this where clause:

where ( number = '184' )

nicocizik

Gerardo,

By default, ReportBuilder removes any leading spaces from field names. This
is deeply embedded in the ReportBuilder source. The only way to change this
behavior would be to modify the TdaSQL.ResolveCriteria method. Inside this
method, there is a function named FormatValue that performs a TrimLeft on
the search expression value. Removing this TrimLeft call may fix your
problem. The TdaSQL.ResolveCriteria method can be found in the daSQL file
in the \RBuilder\Source\... directory.

--

rbuser

Wich packages I need to compile, all of them ??

nicocizik

Gerardo,

You will not want to rebuild any packages. This will only be a run-time
feature so you will only have to change the ReportBuilder source and rebuild
your project with the \RBuilder\Source\... directory in your library path.

--