dbExpress, Dbase and Reportbuilder.
Hi All,
I'm in the process of converting a old product that is currently using the
BDE to access Dbase databases and reporting on them using RB. Tee product
can connect to multiple types of database so it was decided to use dbExpress
for connectivity. I'm using the Open-dbExpress drivers to connect to the
dbase files.
I believe the application in the beginning was built using one of the End
user Database demos supplied with RB as template (..\RBuilder\Demos\4.
EndUser Databases). So I'm performing some testings using the demo to ensure
I can get the connection working but I'm having problems getting the tables
to be accessable through the RB report designer so this would indicate that
I have not got the connections quite right (I'm a newbie to RB so this is a
steep learning curve!)
The original code would be using a BDE alias to point the dbase files but in
the dbExpress implementation we need to use a TSQLConnection. So I've
changed to code as follows where previously the DatabaseName would be an
Alias, it now uses the name of the SQL Connection.
with FReportExplorer.Designer.DataSettings do
begin
SessionType := 'dbExpressSession'; //set the session type to dbExpress
DatabaseName := 'DataCollectionDB'; //DataCollectionDB name of the
TSQLConnection to the dbase files
DatabaseType := dtOther; //not sure if this is correct for DBX and
dbase?
end;
When I execute the Report designer, there are no errors reported but when I
create a new report and then go to the Query Wizard, none of the tables are
listed.
Does anyone have and advice on how to get this to work, it would be very
much appreciated.
Regards,
Chris Hedges
I'm in the process of converting a old product that is currently using the
BDE to access Dbase databases and reporting on them using RB. Tee product
can connect to multiple types of database so it was decided to use dbExpress
for connectivity. I'm using the Open-dbExpress drivers to connect to the
dbase files.
I believe the application in the beginning was built using one of the End
user Database demos supplied with RB as template (..\RBuilder\Demos\4.
EndUser Databases). So I'm performing some testings using the demo to ensure
I can get the connection working but I'm having problems getting the tables
to be accessable through the RB report designer so this would indicate that
I have not got the connections quite right (I'm a newbie to RB so this is a
steep learning curve!)
The original code would be using a BDE alias to point the dbase files but in
the dbExpress implementation we need to use a TSQLConnection. So I've
changed to code as follows where previously the DatabaseName would be an
Alias, it now uses the name of the SQL Connection.
with FReportExplorer.Designer.DataSettings do
begin
SessionType := 'dbExpressSession'; //set the session type to dbExpress
DatabaseName := 'DataCollectionDB'; //DataCollectionDB name of the
TSQLConnection to the dbase files
DatabaseType := dtOther; //not sure if this is correct for DBX and
dbase?
end;
When I execute the Report designer, there are no errors reported but when I
create a new report and then go to the Query Wizard, none of the tables are
listed.
Does anyone have and advice on how to get this to work, it would be very
much appreciated.
Regards,
Chris Hedges
This discussion has been closed.
Comments
Which version of ReportBuilder and Delphi are you using?
The first step is to see if you are able to access and view the tables and
data in Delphi with DBExpress. In your test app, try using a TSQLDataset,
TDataSetProvider, and TClientDataset to access some data on your database
then display it in a DBGrid on your form. If you are able to do this
successfully, then the RB DBExpress plugin should have no problems accessing
your data.
See the Enduser Interbase or Oracle DBX examples for how to use the various
DBX components to access data.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com