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"