Help with DADE

rbuser

I'm trying to create a report that uses Advantage tables, the
tables being used reside in separte directories. I can add the
tables in the Data Tab just fine. When I go to the Preview Tab
I get an AE_FILE_NOT_FOUND error from Advantage. Is
there a solution to this problem other than moving the tables
to the same directory.

Using Delphi5, RB 7.01

nicocizik

Hi Charley,

Using Advantage, you will need to have all your table files in the directory
defined by your connection path.

--

rbuser

I must not have been clear in explaining what I'm attempting to do.
I'll try to explain better.

Here are my Advatage tables and there locations

EmailInfo.adt - Located in X:\AppDir\Data
UserInfo.adt - Located in X:\AppDir\Data\PrimaryData

Defined Advantage Aliases
SYSTEM=X:\AppDir\Data;A
PRIMARY=X:\AppDir\Data\PrimaryData

In the Data Tab of the Report Designer I've added a Query for each
and linked EmailInfo to UserInfo by the field "MasterKey" in each table.

I'm not using TAdsConnection or TAdsTable to access the tables, the
tables are accessed from within the Report Designer by using the defined
Advantage Aliases.

Since I can add both tables in the Data Tab shouldn't I be able to print
the report with no problem.

I hope I was a little more clear this time, if not I can paste how the
TppReport object is defined.

nicocizik

Hi Charley,

In order for the ReportBuilder to connect to your Advantage database, it
needs a TAdsConnection object. If you do not have one defined on your form
or data module, the plugin will use the default connection and the
information in the Ads.ini file. DADE is allowing you to create dataviews
for each table, because it is creating a new default connection for each
table. Then when you try to run a single report that uses both dataviews,
you have a conflict.

--

rbuser

Thanks for the info, I worked out a solution for my problem.