SQL 2000 don't accept cross reference within tables in different databses...
So I was looking for an alternative solution for this.
but it have to be within the DBMS
Thanks
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Carey Matthew Black
Sent: Wednesday, May 03, 2006 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Foreign key on table.
Ignacio,
With that said.... I think your best approach is to solve this with an
ARS methodology. Make the Application enforce the logic, not the
RDBMS.
Add filters that verify the FK value in the other table. If filters
find a problem, then throw an ARS error. (Error might be, missing
value, non-unique value, etc...)
To allow the Application to have access to the foreign table then you
likely need to look at either Direct SQL and/Or an ARS View form.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.
On 5/3/06, Axton <[EMAIL PROTECTED]> wrote:
> Foreign keys are a foreign concept when it comes to ARS.
>
> At the db level you can do whatever you please, though there may be
> unintended consequences when doing so on ARS built tables:
> - consider that certain ARAdmin operations drop and recreate the table
> (alter decimal field precision, etc.)
> - consider that if a user violates a constraint enforced by Oracle,
> Remedy will return the appropriate ORA-xxxxx error to the user; traps
> for these types of errors are non-existent.
>
> Axton Grams
>
> On 5/3/06, Rusconi, Ignacio (I.) <[EMAIL PROTECTED]> wrote:
> > **
> >
> >
> > Does anybody knows how to implement a foreign key to another database in the
> > same instance....?
> >
> > SQL 2000
> > ARS 5.01
> >
> >
> >
> > Ignacio G. Rusconi
> > Data Base Administrator
> >
> > Ford Argentina-TeleTech
> >
> > :.4756-9367.:
> >
> > [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
> > Web. http://pacheco.ba.ford.com/pl/9898
> >
> > ¿Sentiste un Ford últimamente?
> >
> > STRICTLY CONFIDENTIAL. The contents of this e-mail and any attachments are
> > strictly confidential and property of Ford Argentina S.C.A. They may not be
> > used or disclosed by someone who is not a named recipient. If you have
> > received this e-mail in error please notify the sender by replying to this
> > email inserting the word "Misdirected" as the message and delete the present
> > message.__20060125_______________________This posting was
> > submitted with HTML in it___
> >
> >
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
