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

Spaces in Search Criteria Value

edited April 2003 in End User
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' )

Comments

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

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2003
    Wich packages I need to compile, all of them ??


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

    --
    Best Regards,

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