[DUG] ECO Question

Richard Vowles Richard.Vowles at borland.com
Thu Jun 16 15:33:44 NZST 2005


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).
 
---
Richard Vowles
Borland Solutions Architect
DDI: +64-9-9184573, Cell: +64-21-467747
email and IM/MSN: richard.vowles at borland.com
Skype: rvowles
 

  _____  

From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Jason Saggers
Sent: Thursday, 16 June 2005 2:34 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] ECO Question


Ok - Have gotten closer.
 
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.
 
Jason

  _____  

From: Jason Saggers 
Sent: Thursday, 16 June 2005 2:08 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] ECO Question


Reverse engineer a database, and then go from there.
 
The database has no relationship defined, and i am having issues trying
to relate them with the model.
 
E.g.
 
Table 1
 
job
 
job_id
..
..
..
...
..
 
 
Table 2
 
rest_job
 
job_id
..
...
...
...
 
and so one.
 
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.
 
 
Jason

  _____  

From: Richard Vowles [mailto:Richard.Vowles at borland.com] 
Sent: Thursday, 16 June 2005 1:58 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] ECO Question


I'm a little lost as to what you are trying to achieve? 
 
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?
 
Richard
 
---
Richard Vowles
Borland Solutions Architect
DDI: +64-9-9184573, Cell: +64-21-467747
email and IM/MSN: richard.vowles at borland.com
Skype: rvowles
 

  _____  

From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Jason Saggers
Sent: Thursday, 16 June 2005 12:04 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] ECO Question



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.

My problem is that I don't seem to be able to get a relationship defined
that works. 

All the tables (mostly) are linked on a int based id column. 

Any help very much appreciated. 

Jason 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20050616/5b76998d/attachment.html


More information about the Delphi mailing list