Store Procedure

rbuser

Hi,

I need to select given from a Store procedure,
but I do not obtain to include a Store Procedure in
my Data Dictionary .

Exists some way?

Sorry my English !! :-)

Eduardo Gomes
Campo Grande
Brazil.

nicocizik

Hi Eduardo,

Currently there is no support built-in to the Query tools for supporting
views or stored procs.

1. You may be able to modify the DADE Plug-in that you are using to get a
list of available views included with the available tables.

In each of the DADE Plug-ins there is TdaSession descendant class that
overrides a method called GetTablenames. This is where you would need to add
some additional code. If you are using the BDESession, daDBBDE.pas is the
source unit, if you are using IB Express then daIBExpress.pas is the source
unit for the DADE Plug-in.

2. For stored procs you would probably need to create a new DataView class
and associated Data Wizard and register them with RB.

--