<!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=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>