CreateAutoSearchCriteria and aFieldName

rbuser

Hi,

I'm using Delphi 7 and ReportBuilder 7 Enterprise.

I've been creating AutoSearch criteria in RAP with very little difficulty,
and I'm using the DADE to create queries. However, now I have a small
problem. My datapipeline has two different fields from different tables
with the same fieldname, so when I create the AutoSearchCriteria, the wrong
field is used. Because of the calculations I'm doing, I can't put these two
table in different pipelines. The pipeline is 'PlantInfo' but two tables
(EQUIPTYPELIST and EQUIPTYPESUPP) are joined in the pipeline. Both tables
have the field EQUIPTYPE in them.

function CreateAutoSearchCriteria('PlantInfo', 'EquipType', soEqual,
'Vessel', True:);

Is there a way around this?

Thanks,

Leah

nardmoseley

The other approach to creating AutoSearch Criteria for DADE SQL DataViews is
to extract the TdaSQL object from the DataView and use TdaSQL methods to
create the criteria and designate it as autosearch. For an example of
extracting the TdaSQL Object and creating crieria please download the
following:

http://www.digital-metaphors.com/tips/ExtractSQLObject.zip


First get a solution working using Delphi code. Then you will need to write
a RAP pass-thru function that can be called from RAP code.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com