QueryDesigner,DataTab and Advantage Tables

rbuser

I am trying to implement the datatab for Reportbuilder 6.03, Delphi 5,
and Advantage Local server 6.2, so I can use the QueryDesigner and
QueryWizard. I have placed the daDatMan.pas and daADS.pas in
the path and have made the correct settings in the Data Settings.
I now get the DataTab, QueryDesigner and QueryWizard within
the File/New of the Report, however no tables show up. I have looked
at the example that comes with Reportbuilder and it does the same thing
unless I use the datadictionary option. Then the demo tables show up.

I have noticed that the demo is distributed with version 5.5 of
Advantage. Could this be the problem? I am using the latest version.
Is there a newer version of daADS out.

Does anyone have a working example of using Advantage with Report
Builder?

Any help would be greatly appreciated as I am stuck in the water, so to
speak.

Thanks,

Brian

digitalmetaphors

Are you using the Advantage data dictionary? Disconnect that data
dictionary. You should use the ReportBuilder data dictionary component in RB
6.03 to control the tables, fields and joins available to the report
designer. The daADS.pas that ships with RB 6.03 doesn't support the
Advantage 6 data dicitonary feature. Currently, RB 7 has an issue with the
current Advantage data dictionary when using linked data dictionaries, but
it should work with a single Advantage data dictionary. You can upgrade to
RB 7 to get the latest support for Advantage 6 in RB. When the linked data
dictionary support comes out, you'll be able to get support for that if
you're using RB 7. However, we won't force you to upgrade to RB 7, just to
get the latest plugin. However, you'll have to modify the 6.03 version of
the plugin based on the 7 version of the plugin. The architecture is a
little different because RB 7 supports thread safety. The changes aren't
drastic, just a couple of interface section changes in the plugin. I can
send you the RB 7 plugin and you can adapt it to work in RB 6.03. It
basically adds a couple of methods that get the data from the Advantage data
dictionary. Compare the two files and it should be easy to build a working
version.

Send an email to support@digital-metaphors.com and we'll send you the RB 7
daADS.pas.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I have projects that use both. How or what do I do for a project that
does not use a data dictionary.

Brian

digitalmetaphors

If you are using the Advantage data dictionary, you'll want to use the same
plugin for both projects. There is a selection statement in the latest
plugin to get the tables from either the Advantage datadictionary or from
the normal ways: hit the database, read our data dictionary or read from the
meta data cache. I can send you the latest RB 7 daAds.pas and you can adapt
the new code to your 6.03 version of daAds.pas so that it can work this way
for you.


Cheers,

Jim Bennett
Digital Metaphors