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.
Comments
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.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com