DatabaseName property continually losing its setting

rbuser

I use Delphi 7 and Advantage database, RB V7.

In order to overcome a problem whereby database traversing does not work
properly, we have found it is necessary to continually re-enter a nested
property within ppReport components.

The property is DataPipeline/Datasource/DataSet/DatabaseName.

We have further found that it is necessary to use an Advantage Database
Alias rather than the name of the Advantage AdsConnection component in
order to retrieve any report data at all.

I need to know if it is possible to set these properties in code, and if
so using what syntax, and further if there are problems with Advantage
drivers in general.

At the moment the RB component is unuseable, as we cannot trust the
database connection.

Please advise as a matter of urgency.



--- posted by geoForum on http://delphi.newswhat.com

rbuser

Further information on this problem...the ppReport DataPipeline property
changes after a report run is attempted, from the original setting of the
Datasource name, eg dsTable, to a setting which obviously the Advantage
driver has detemined, eg daADSQueryDataview1.tablename.

Are there other users out there having problems with RB and the Advantage
driver?






--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Sairheid,

My first suggestion would be to update your version of ReportBuilder to
7.04. RB 7.04 added support to allow a connection to an Advantage database
using a connection path rather than just an alias or datadictionary
connection. This is a free upgrade for registered RB 7.x users. Please
contact info@digital-metaphors.com with your serial number and purchasing
email address for upgrade instructions.

You should not have to set the DataPipeline.Datasource.Dataset.DatabaseName
property manually. If you take a look at the Advantage demo located in the
\RBuilder\Demos\4. EndUser Databases\Advantage\... directory, you will see
that there is a TADSConnection object on the form that is connected to the
database. It is necessary to have this component available either on your
form or in a datamodule. This TADSConnection is connected to each dataset,
which is connected to each datasouce and to the datapipeline and so on.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

We have a TADSConnection component in our sample project.

I will pursue the updated version as you suggest.


database
purchasing
DataPipeline.Datasource.Dataset.DatabaseName
the
see
the
your
dataset,
work
nested
if



--- posted by geoForum on http://delphi.newswhat.com