database joins

rbuser

Dear all,
following advice last month, I have used the data dictionary
component to populate the tables and fields, and not the joins. I do not
want the suggested joins based on same filed names.
I have then added the join in the data dictionary. I have checked the
database using Enterprise manager and the record looks fine.

When I use the reporting tool to create a new report, and use a new data
wizard, I choose the two tables and it immediately suggests a join using the
same field names and totally ignores the join I have defined.

How do I get the data builder to use the joins I define??

regards

--
John Evans
Technical Director
Clear Advantage Ltd

www.Clear-Advantage.co.uk

digitalmetaphors

Set UseDataDictionary to true in the designer's Datasettings property, or at
runtime in the datasettings dialog of the Data tab. If you don't tell the
designer to use the data dictionary, it will try to join on those fields
automatically as a suggestion.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Dear Jim,
many thanks.

I now have the database structures I want in my rb_xxx tables. Is there an
easy way of writing a program to update the database of my customers to
build all of the tables?

regards
John

digitalmetaphors

Hi John,

There are SQL scripts in our demos which create the end user tables for the
folders, items, tables, fields and joins. I searched on older posts but OE
is not finding your oldposts so I could see what DB you are using. Anyways,
for your database, look in the applicable RBuilder\Demos\EndUserDatabases
directory for and example script or sample tables.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Dear Jim,
sorry, I am misleading you. I can see how to use the scripts to
create the tables, I want to populate them once they have been created,
using the data in my database. The database is SQL server.

regards
John