Search Criteria

rbuser

Is there a way to get the search criteria from one table and use it in
another.

nicocizik

Hi Pazzaz,

If you are using Dade, you can easily use the TdaSQLBuilder class to obtain
an entered search criteria and create a new one to be applied to the report.
Take a look at the help topics on TdaSQLBuilder for information and code
examples and the rbWiki articles below.

http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder

If you are using Delphi, try using the methods similar to the AutoSearch
demos located in the \Demos\AutoSearch\... directory to add and remove new
search criteria for your report.


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nardmoseley

RB 11 provides a RAD solution for this.

RB 11 includes major enhancements to Parameters, AutoSearch, and the DADE to
enable this to be done without writing any code.

1. From the Design workspace you can add a Parameter and use the object
inspector to configure AutoSearchSettings and LookupSettings.

2. From the Data workspace you can use the Query Designer to create search
criteria that bind to the Parameter. So you can have many query's that bind
to the same parameter.

www.digital-metaphors.com/rbWiki/General/What's_New/RB_11/Parameters_and_AutoSearch


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