I prefer to make a local DB view that has the dbLink and make my Remedy
View form local for 2 reasons.

1.  This way my Remedy code/form does not change between
Dev/Test/Production servers.   
2.  I can manipulate the Oracle data so I can see other types inside
Remedy.   
    (i.e. I can convert the Oracle dates to numbers so I can see them as
DateTime   
     fields inside Remedy).

Fred 

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt
Sent: Friday, January 18, 2008 12:40 AM
To: [email protected]
Subject: Re: Debugging Issue with View Form and a DB LINK

Hi,

We are looking into different ways to deal with this issue and we will
certainly be taking your suggestion on board. Thanks for this.

We are using a DB Link to create a View Form within the Remedy System so
we are not using a local DB view.

Thanks.

Nyall

Grooms, Frederick W wrote:
> How about using CAST or TO_STRING to make the value a varchar(15).
>
> Did you say you made a local DB view that uses the dbLink and a Remedy

> view form on that?
>
> Fred
>
>   

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to