New Blog Post: RESTful Reporting

SQL Parameter problem

edited March 2010 in DADE
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:-

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.



  • edited March 2010
    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.


    Nico Cizik
    Digital Metaphors

    Best Regards,

    Nico Cizik
    Digital Metaphors
  • edited March 2010
    Thanks for the advice Nico, I'll have a look now.


This discussion has been closed.