Hello Elizabeth, I saw this happen once before. It was with a remote instance of MS SQLServer though. I think it had to do with the fact that the Sequence number is not stored anywhere. It was made up "on the fly". I had to resort to using a field that existed with stored data in it. Though it wasn't always unique (nulls allowed) I was still able to use the view as a lookup for other data. We didn't care about records that had a null in the field we used as a Request ID. Now, it did throw errors every now and again. For our short term purposes it worked. HTH a little,
John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Feulner, Elizabeth C (X-KAPL A LM Company) Sent: Wednesday, May 23, 2007 9:32 AM To: [email protected] Subject: Highlighted Results List values do not match data in form ** ARS 6.3 patch 20 HD 6 Windows 2003 Oracle 10g I created a Remedy view form so that I could access an Oracle view and pull the data into a new remedy form. The Oracle view consists of 3 oracle tables linked together by field DocNum. The Oracle view has a sequence number that gets pushed to the request id field of the new remedy form. Sequence number was added so that I have a unique value to push to the Remedy view form. Here's what happens. I open the Remedy View form and search on Request Id 9862 (sequence number from oracle). The fields in the View form fill in from the query, but the fields listed in the results list does not match the data displayed on the View form fields. The request id field is the same on the View form and the results list, however, but all the other fields displayed on the results list (5 of them, including DocNum) are different that the data displayed in the fields. If I search on a DocNum instead of Request Id the data appears in the results list, but the DocNum is different than what I searched on. Again, the request id is correct but the other fields in the results list are not the same as those in the fields. How can this be fixed so that the results list fields data matches the data displayed on the field on the form? __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
