DADE & FoxPro Tables

rbuser

Is it possible to use ReportBuilder with FoxPro Tables? These are readable
with Advantage but using the Advantage components and these tables does not
seem to be successful with ReportBuilder.

I am using the following components:

ppReport --> ppDBPipeline --> DataSource --> AdsTable --> AdsConnection

(I have also tried AdsQuery in place of the AdsTable.)

On the Data tab in ppReport, the Database Setting are : ADSSession, the
AdsConnection name, Advantage, ASCII, LocalSQL or SQL1

With the AdsConnection active, Clicking New allows the start of Query
Wizard or Query Designer but no tables are available. Am I missing something
or is this impossible to do?

Tom

nardmoseley

1. For an example of using Advantage with the EndUser solution, check out
RBuilder\Demos\EndUser Databases\Advantage. There is a ReadMe.doc includes.

2. Configure the Ads.ini file with an Alias that includes the appropriate
tabletype. Then specify the Alias in the ADSConnection. The
Designer.DataSettings.DatabaseName should reference the AdsConnection
component.






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

rbuser

> 1. For an example of using Advantage with the EndUser solution, check out
includes.

I have done that and everything works fine with Advantage ADT tables.
However, I can't get it to work with PDF tables although Advantage has no
problem with them.

Tom

nardmoseley

There are no known issues with using dbf tables. When you specify the Alias
in the Ads.ini file it needs to have a ";C" at the end to indicate dbf
tables.

If you would like to zip the dbf tables and e-mail to
support@digital-metaphors.com we can test it out here.


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