DADE not showing tables in Advantage

rbuser

Hello all...

I'm using RB 6.02 Professional, Advantage TDataset 6.11 and Delphi 5.01. I
have been using RB for a long time but this is my first opportunity to use
DADE and End-User reporting.

I have installed rbAds55.xxx in the Delphi IDE and have added the correct
units in the "Uses" clause. I do get AdsConnection and everything is in
place and operating as it should be in both the Report and the Report
Explorer. My end user report comes up and I can see the "Data" tab. If I
click "New" I do see the Query Wizard and the Query Designer however when I
continue with either of these utilities I do not see any tables. I am not
using the Data Dictionary as it was my understanding that this was optional.
I prefer not to use it because of the number of tables and fields involved.

I can build reports with no problem (the DBPipelines show up properly in the
Report itself) but I cannot access tables/fields in the Query
Wizard/Designer. My end users will need to filter dates, etc. in their
reports but I cannot see how they will be able to do it without using the
Query utilities.

What might I be doing wrong such that the tables are not showing in the
Query Wizard or Designer? For further information, the report has one master
table and 12 child tables which all link separately to the master (i.e.,
only one level of child tables). I have looked at and compiled all the End
User demos as well as read and re-read the RBDeveloper PDF file. I have
searched this NG and I still cannot figure out what's wrong.

End User reporting seems to be VERY powerful and works great! My hat is off
to Digital Metaphors!! Now, if I can only build a Data Template I will be
EXTREMELY happy!!

Thanks in advance for any help...

Jan Ferguson
Data Software Solutions, Inc.

digitalmetaphors

Advantage 6.11 was just released and we haven't tested with it yet. Are you
using the Advantage datadictionary? This is a new feature they have. We need
to test with 6.11 before we'll have any definite answers. Thankyou, for
your patience.


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

Use the AliasName instead of a path on the Advantage database component. The
current DADE plugin is currently limited in this regard.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

I do use the AliasName and I am using the Data Dictionary in Advantage.
Actually the Data Dictionary has been in use since v6.0 but it is now more
stable under v6.11.

Thanks for your input on this.If you need anything else on this to help
yhou...let me know.

Regards,
Jan Ferguson
Data Software Solutions, Inc.

digitalmetaphors

You say that our end user demos are working on your machine, so there must
be a configuration problem. Check the DataSettings property on the Report
Designer component. This is how DADE knows where to find the database.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

I've checked, re-checked and double-checked and everything appears to be
correct. I have integrated the ReportExplorer and as such am now also using
the RB Data Dictionary. That is working perfectly also.

I've checked the DataSettings properties on the Report Designer component. I
am using ADSSession, the correct Alias (I have also tried it using the
Advantage Database Connection value), the RB Data Dictionary value and have
indicated "TRUE" to using the Data Dictionary. All to no avail. I still
cannot see table/field values in the Query Wizard/Designer.

I've even tried the rbTable and rbField databases (as far as the
DataSettings) to see if they would show the tables/fields but again to no
avail.

Could it be due to the use of Advantage Data Dictionary? Maybe RB is looking
for "free tables" as compared to tables in a Data Dictionary.

I have a little time left before I deploy this app at the end of November
but I'd sure like to get this figured out as it's driving me nuts!!

Regards,
Jan

digitalmetaphors

Try disabling the Advantage DataDictionary.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I thought about doing that but I have 87 tables in the Advantage Data
Dictionary. I would have to unencrypt each table, free the table from the
Dictionary and change some code in my application to disable the Advantage
Data Dictionary.

I was hoping that I could try something else before I went to that extent.
It may come down to that though.

Jan

rbuser

Jim,

I tried some other things with "free tables" (not in the Advantage Data
Dictionary) and the Query Builder, etc. in RB worked fine. Now I am certain
that the problem is the ADS Data Dictionary. (currently using version 6.11)

The strange part is that although I can't "generate" the tables from my
database connection, it will generate the fields properly after I have added
the tables manually. Unfortunately, even though I add the tables manually in
RB's Data Dictionary, it does not show under the Data tab.

Where do we go next with this? Is RB looking at updating the Advantage DADE
Plug-In or do we have to wait for some Advantage user (who has the knowledge
and ability) to do this? I will be putting this product out to beta the
middle of November and I would like to include this option. Unfortunately,
because of the RI cascading updates and cascading deletes in the ADS Data
Dictionary, I can't go without using it. The deletes are no problem but with
the number of child tables, cascading updates are a real pain!!

Please give me some good news....!

Regards,
Jan Ferguson
Data Software Solutions, Inc.

digitalmetaphors

We are aware that there are issues with the Advantage DataDictionary and RB.
We aren't currently supporting it in the DADE plug-in. Sorry, but we have
no immediate plans for upgrading the plug-in at this time.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

I'm really sorry to hear that.