End user need

rbuser

Our end user has created a VIEW in the our application's database. Is thier
a way for them to create thier own reports that take into account that view
without us having to recode?
-- xavier

--
_____________________________________________
Xapware Technologies Inc.
http://www.xapware.com
Application Lifecycle Management
Active! Focus

nardmoseley

The Query tools rely upon the applicable DADE plug-in all data access
functionality - such as retrieving the available table names. By default
"views" are not supported, but can be added by modifying the GetTableNames
method of the TdaSession descendant class.

As an example: If you are using ADO connectivity, the DADE plug-in source
code unit is RBuilder\Source\daADO.pas. You can modify the
TdaADOSession.GetTableNames method to retrieve the views for the database.
By default the TdaADOSession.GetTableNames method calls the
TADOConnection.GetTableNames method. You can add code to retrieve the view
names.

I just searched Google and found some info on using the
TADOConnection.OpenSchema method to retrieve views.

ADOConnection1.OpenSchema(siViews, EmptyParam, EmptyParam, MyListOfViews);
//myListOfViews is a TADODataset

To build a list of names, navigate through the dataset, and call:

MyStringList.Add(MyListOfViews.FieldByName('TABLE_NAME').AsString);



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com