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 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt Sent: Thursday, January 17, 2008 6:27 AM To: [email protected] Subject: Re: Debugging Issue with View Form and a DB LINK Hi, Unfortunately I can't change the data. It is coming from an external source (actually a MySQL database) which is then imported into an Oracle database for processing by a different project. I am then trying to access the same data within Remedy for a specific Remedy application. Perhaps if I copy the original field, which is defined as number(38) to a character field of 15 characters then that might work? Thanks. Nyall Misi Mladoniczky wrote: > Hi, > > 999000000000317 seems too big for an integer. > > Could you possibly use less digits? > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > * RRR|Translator - Manage and automate your language translations. > Find these products, and many free tools and utilities, at http://rrr.se. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
