Passing parameters to query

rbuser

Using Delphi 2006 and RB Enterprise 10.07. I want to create queries in my
report using DADE and be able to pass parameters to the queries. I have
setup my two parameters on my report, but not sure how to get them to be
passed to the query.

Also, in the Data tab, how can I delete a query?

Thanks,

David

rbuser

Nico,

How do I use the AutoSearch feature? Can I edit the SQL through code to
input the correct search paremeters?

Thanks,

David

nicocizik

Hi David,

Parameterized queries are currently not supported in DADE. This is
something we are strongly considering for the next major release. Currently
you will either need to use the AutoSearch feature or edit the SQL manually
(removing all linking capabilities).

You can delete a query by right clicking over a dataview and selecting
"Delete" from the popup menu.

--
Regards,

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

rbuser

Hi David,

Yes, you can. See the OnGetAutoSearchValues() event in the online help and
the 'Demos\5. AutoSearch' directory for more information.

Regards,
Jeroen.

nicocizik

Hi David,

Take a look at the autosearch demos located in the \RBuilder\Demos\3.
AutoSearch\... directory. This feature gives you the ability to change the
search condition while you are previewing the report.

If you would simply like to change the SQL manually in code, take a look at
the TdaSQLBuilder class in the daSQLBuilder.pas file. This class gives you
numerous easy to use routines that allow you to access and manipulate the
SQL object very easily. See the help topic for TdaSQLBuilder and its
accompanying classes for code example and more information.

--
Regards,

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