There is no built-in support to DADE for either of these.
You can modify the DADE Plug-in you are using to support Views, by overriding the Session.GetTableNames method. For example, if you are using ADO connectivity, open RBuilder\daADO.pas and modify TdaADOSession.GetTableNames.
Internally the DADE Plug-ins create a QueryDataView descendant class. See the DADE thread of Tech Tips newsgroups for an overview of the architecture. A QueryDataView can work with the QueryDesigner and QueryWizard tools. Internally the QueryDataView creates a DataSet, DataSource, and DataPipeline. For example, ADOQueryDataView creates an ADOQuery, TDataSource, and DBPipeline.
To support StoredProcs you can create custom dataview - see RBuilder\Demos\EndUser\Custom DataViews for examples.
I am trying to use the example you mentioned in your reply but with interbase instead of Paradox. (RBuilder\Demos\EndUser\Custom DataViews).
So I copied myQueryDataVw and MyDataVw classes to RBuilder\Demos\EndUser Databases\Interbase\BDE directory added the unit names to the uses clause.
Also I changed TdvCustomer Dataview to cater for the Customer table in the Employee.gdb database. Also set the DatabaseName := 'euDatabase'; in the Create. and run the program, now I can see the templates tab page. (so far so good).
When I select the Customer Template to use I get the following error
General SQL error token unknown - line 6, char 6 "customer".
Comments
There is no built-in support to DADE for either of these.
You can modify the DADE Plug-in you are using to support Views, by
overriding the Session.GetTableNames method. For example, if you are using
ADO connectivity, open
RBuilder\daADO.pas and modify TdaADOSession.GetTableNames.
Internally the DADE Plug-ins create a QueryDataView descendant class. See
the DADE thread of Tech Tips newsgroups for an overview of the architecture.
A QueryDataView can work with the QueryDesigner and QueryWizard tools.
Internally the QueryDataView creates a DataSet, DataSource, and
DataPipeline. For example, ADOQueryDataView creates an ADOQuery,
TDataSource, and DBPipeline.
To support StoredProcs you can create custom dataview - see
RBuilder\Demos\EndUser\Custom DataViews for examples.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Thanks for your speedy reply.
I am trying to use the example you mentioned in your reply but with
interbase instead of Paradox. (RBuilder\Demos\EndUser\Custom DataViews).
So I copied myQueryDataVw and MyDataVw classes to RBuilder\Demos\EndUser
Databases\Interbase\BDE directory added the unit names to the uses clause.
Also I changed TdvCustomer Dataview to cater for the Customer table in the
Employee.gdb database. Also set the DatabaseName := 'euDatabase'; in the
Create. and run the program, now I can see the templates tab page. (so far
so good).
When I select the Customer Template to use I get the following error
General SQL error token unknown - line 6, char 6 "customer".
Am I missing something?
Regards
NB