DADE does not support parameter queries like the Delphi TQuery. You will need to use the AutoSearch feature to specify search conditions. A dialog can then be optionally be shown to the end user and the DADE SQL is automatically rebuilt for the WHERE clause. See the following article on how to create AutoSearch parameters in DADE. Examples of this are located in the \RBuilder\Demos\End User\... directory.
---------------------------------------------------- Tech Tips: Creating AutoSearch parameters via DADE ----------------------------------------------------
1. Access the Data workspace of the Report Designer.
2. Create a DataView using the Query Wizard or Query Designer.
2. A DataView tool window will be displayed in the data workspace.
3. Press the Search button. The Search tab of the Query Designer will be displayed.
4. Add a search criteria item and select the AutoSearch checkbox. You can optionally select Mandatory as desired.
5. Close the query designer.
6. Now when you select the Preview tab of the Report Designer. A search button will appear on the toolbar. This displays the AutoSearch dialog.
7. By calling Report.Print in code, or by selecting print/preview from the report explorer the AutoSearch dialog will be automatically be displayed.
Comments
DADE does not support parameter queries like the Delphi TQuery. You will
need to use the AutoSearch feature to specify search conditions. A dialog
can then be optionally be shown to the end user and the DADE SQL is
automatically rebuilt for the WHERE clause. See the following article on
how to create AutoSearch parameters in DADE. Examples of this are located
in the \RBuilder\Demos\End User\... directory.
----------------------------------------------------
Tech Tips: Creating AutoSearch parameters via DADE
----------------------------------------------------
1. Access the Data workspace of the Report Designer.
2. Create a DataView using the Query Wizard or Query Designer.
2. A DataView tool window will be displayed in the data workspace.
3. Press the Search button. The Search tab of the Query Designer will be
displayed.
4. Add a search criteria item and select the AutoSearch checkbox. You
can optionally select Mandatory as desired.
5. Close the query designer.
6. Now when you select the Preview tab of the Report Designer. A search
button will appear on the toolbar. This displays the AutoSearch dialog.
7. By calling Report.Print in code, or by selecting print/preview from
the report explorer the AutoSearch dialog will be automatically be
displayed.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com