<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>ECO Question</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=687502903-16062005><FONT face=Arial
color=#0000ff size=2>If you are doing it that way instead of editing the XML
file to reference the Object in multiple tables, you will want to use an OCL
Variable Handle and then an OCL Variables object. You probably want to try
creating the Job object and then specifying when tables it is in though? Either
that, or you can draw the reference as a 1..1 relationship and then specify in
the XML mapping how that relationship is realized and then you can reference it
via job.restjob.fields (which is a bit yucky, but quick).</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>---</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Richard Vowles</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Borland Solutions Architect</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>DDI: +64-9-9184573, Cell:
+64-21-467747</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>email and IM/MSN: <A
href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Skype: rvowles</FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Jason
Saggers<BR><B>Sent:</B> Thursday, 16 June 2005 2:34 p.m.<BR><B>To:</B> NZ
Borland Developers Group - Delphi List<BR><B>Subject:</B> RE: [DUG] ECO
Question<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=698433202-16062005><FONT face=Arial
color=#0000ff size=2>Ok - Have gotten closer.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=698433202-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=698433202-16062005><FONT face=Arial
color=#0000ff size=2>Need a good OCL referencer guide now. Need to be able
to take and id from my job class and use it to select using derived from my
rest_job class.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=698433202-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=698433202-16062005><FONT face=Arial
color=#0000ff size=2>Jason</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Jason Saggers <BR><B>Sent:</B> Thursday,
16 June 2005 2:08 p.m.<BR><B>To:</B> NZ Borland Developers Group - Delphi
List<BR><B>Subject:</B> RE: [DUG] ECO Question<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>Reverse engineer a database, and then go from
there.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>The database has no relationship defined, and i am having
issues trying to relate them with the model.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>E.g.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>Table 1</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>job</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>job_id</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>Table 2</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>rest_job</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>job_id</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>and so one.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>these table combined describe a job. The commonality
between all the different pieces of the job, which is stored across a number of
tables in the job_id column, And I would like to be able to navigate down
the classes by having them associated within the model without having to make
changes to the database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=389270402-16062005><FONT face=Arial
color=#0000ff size=2>Jason</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Richard Vowles
[mailto:Richard.Vowles@borland.com] <BR><B>Sent:</B> Thursday, 16 June 2005 1:58
p.m.<BR><B>To:</B> NZ Borland Developers Group - Delphi List<BR><B>Subject:</B>
RE: [DUG] ECO Question<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=906365701-16062005><FONT face=Arial
color=#0000ff size=2>I'm a little lost as to what you are trying to achieve?
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906365701-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906365701-16062005><FONT face=Arial
color=#0000ff size=2>Are you trying to put the relationships into the database
or are you reverse engineering the database into a model and then going from
there?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=906365701-16062005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=906365701-16062005><FONT face=Arial
color=#0000ff size=2>Richard</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>---</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Richard Vowles</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Borland Solutions Architect</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>DDI: +64-9-9184573, Cell:
+64-21-467747</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>email and IM/MSN: <A
href="mailto:richard.vowles@borland.com">richard.vowles@borland.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Skype: rvowles</FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Jason
Saggers<BR><B>Sent:</B> Thursday, 16 June 2005 12:04 p.m.<BR><B>To:</B> NZ
Borland Developers Group - Delphi List<BR><B>Subject:</B> [DUG] ECO
Question<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Im building an ECO II app in 2005 (After Richard
repeaked my interest on Tuesday), and the DB that im building against dosent
have any database defined relationship between the tables (these where
maintained in existing code.</FONT></P>
<P><FONT face=Arial size=2>My problem is that I don’t seem to be able to get a
relationship defined that works.</FONT> </P>
<P><FONT face=Arial size=2>All the tables (mostly) are linked on a int based id
column.</FONT> </P>
<P><FONT face=Arial size=2>Any help very much appreciated.</FONT> </P>
<P><FONT face=Arial size=2>Jason</FONT> </P></BODY></HTML>