on 07-12-2005 10:27 AM
hi,
is there a way to define foreign-key relations in NW Dev.studio?
I set up a dictionary project and defined some tables with keys - but how do i manage the foreign keys? I only saw the tabs, columns - indexes - technical settings, and in none of which I can define foreign keys.
thanx for help,
matthias
hi matthias,
Unluckily you cant define keys. Sorry
Greetings
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You cannot do it easily from the Dictionary perspective but there is a workaround. This is what I did:
1) Right click your table in the Dictionary Explorer and select "Create DDL script."
2) Select the target DB platform.
3) Click on the "Navigator" tab
4) Navigate to your ddl script folder src->scripts->
5) You can see a listing of "baseline" DDL scripts that generate the table as you've defined it in the dictionary. You will need to edit the script so that it sets up your foreign key constraint. The syntax for this will depend on the db you use. Your dba should be able to help you execute the ddl script.
Hope it helps,
Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Relationships between tables are handled at the application level in the WAS.
If you are using CMP EJBs to access your tables, you can create a helper table and setup a "relationship" between to EJBs. The relationship is defined using cmr fields in the EJB and managed by the beans, all you have to do is create the heper table in your dictionary project.
Hope this helps,
Erin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.