New Blog Post: PDF/A and Metadata

SQL Parameter problem

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

Comments

  • 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.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2010
    Thanks for the advice Nico, I'll have a look now.

    regards
    Glenn

This discussion has been closed.