Parameters

rbuser

Hi,

I'm trying to use the new Parameters and AutoSearch functionality but I'm
not having much luck. I'm using BDS 2006 with DBISAM 4.

In the Properties for the Parameters what is the DataPipeline property and
how is it used. What is the FieldAlias and how is it used.

I always get an error that "10/1/2008" is not a valid date and time or '' is
not a valid when using the Between operator. I have the parameter type set
to DateTime. I tried setting it to simply Date but it said it was not a
supported parameter type.

Also, it usually gives me an access violation and then all my datapipelines
in Data tab are gone. I'm using DADE to create the data pipelines. I'm
more or less using it as an end-user tool at the moment with a data
dictionary assigned (versus developing the report in Delphi).

Any assistance you can provide is greatly apprecited.

Thanks,
Scott

nardmoseley

The RBuilder help topic for Parameter lists the properties. Then traverse to
the help for Parameter.AutoSearchSettings (i.e. TppAutoSearchSettings).
There you will find definitions for the AutoSearchSettings properties. The
DataPipeline and FieldAlias properties are optional. They can be used by the
AutoSearch dialog. The FieldAlias can display instead of the parameter name.
The DataPipeline can be used to group autosearch fields into notebook tabs
on the autosearch dialog. These properties provide compatibility to support
pre-existing autosearch features.


There is a patch now available. We added support for the dtDate, dtTime
datatypes. The datatype conversion errors are fixed.

When using the Between operator you can specify two values for the
SearchExpression - separated by a comma, for example, 10/1/2008, 1031/2008.
However the Parameter.Value property will only show the first value. So for
multi-value search operators always use the SearchExpression property.





--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com