Stored Proc's

rbuser

Hi guys

I use the end user report solution and use Data Dictionary.

What s the best way to gain access to Interbase/Firebird Stored Procs or
views. Is it to include these as tables in the Rb_TABLES table ?

How would I go about passing params to the stored procs ?

Many thanks

Mark

PS Keep up the great work, the recent advice you gave me regarding pass thru
functions worked a treat!!

nicocizik

Hi Mark,

1. Views

We have modified some of the DADE plug-ins to include Views. If the DADE
plug-in that you are using does include views in the list of available table
names, then modify the GetTableNames method of the plug-in. For example, if
you are using ADO and find that it does not include views, then modify
TdaADOSession.GetTableNames in daADO.pas.

2. Stored Procedures

This is still on our To Do list. The options are to manually edit the SQL of
a dataview or create a custom dataview class
(RBuilder\Demos\CustomDataViews).

--
Regards,

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

rbuser

Nico

Excuse my ignorance but can you briefly explain what a custom data view
class is ? What functionality will this replace ?

Cheers

Mark

nicocizik

Hi Mark,

The DataView class is an abstract ancestor to the QueryDataViews you see in
the data workspace (i.e. DADE). The dataview class gives you access to the
SQL that will be executed in your database. Creating and registering your
own custom dataview will give you the ability to gain complete control over
the SQL code used. Take a look at the TdaDataView topic in the
ReportBuilder help along with its descendents for more information on how
the data architecture works.

--
Regards,

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