SQL Parameter problem

rbuser

Hi,
Im using reportbuilder 7.04 (D6) and admittedly my delphi skills are a bit
rusty so please bear with me. I have to return a complex dataset from an
Oracle database, too complex to put into a view. I've a series of
parameterised functions which retrieve the individual datafields a follows:-
ie

select
function1(:p1, :p2, :p3),
function2(:p1, :p2, :p3)
from table

my question is how can use the AutoSearchField dialog to specify values for
:p1, :p2 etc ? can the AutoSearchField dialog only be used for parameters in
the where clause ?

I need to get the end user to specify these values prior to them executing
the report and using the autosearchfield dialog seems the most convenient
way to do it.

regards
Glenn

nicocizik

Hi Glenn,

Take a look at the AutoSearch demos located in the RBuilder\Demos\5.
Autosearch\... directory. Specifically the "AutoSearch Field to SQL Params"
example. This shows how you (in code) can use the autosearch values entered
in a SQL statement manually.

Note that for RB 11, you would be able to do this in DADE using manual SQL
and no code.

--
Regards,

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

rbuser

Thanks for the advice Nico, I'll have a look now.

regards
Glenn