RB7 --> RB10 Change in SetSearchExpression logic

rbuser

I have been encountering exceptions in the debugger for some reports
that use a combination of date and time in 'between' clauses. The
exception only occurs in the IDE, but it is clearly a change in
behavior and I am not sure if there is a deeper problem or not.

For databases that support a datetime datatype, a datetime might be
entered as:

'01/01/2006 10:00:00 AM'

For a range:

'01/01/2006 10:00:00 AM,02/01/2006 10:00:00 AM'

When TppAutoSearchField.SetSearchExpression is called, there is logic
that now surrounds each side of the range expression with quotes if
there is an embedded space in the argument:

'''01/01/2006 10:00:00 AM'',''02/01/2006 10:00:00 AM'''

When each expression is later separated from the range and sent to
convert the str to a datetime in TdaCriteria.AddNumericValue method,
the quotes are not being stripped out and an exception is occurring.

This does not have any adverse effect on the evaluation of the
arguments for the query as far as I can tell, but I thought I would ask
about this behavior. Anything to be worried about other than the
behavior while running through the IDE?


--
Bob McClintock

nardmoseley

Thanks for reporting this - we had not tested that case. I will email you a
patch I created for RB 10.02 that fixes it.