Simon, Just a quick sanity check...
When you create the new field. On the Field property, DB tab, are you sure that the "View information" section is filled out correctly? Also.. If you do a select of the table with your key field value does that only return one record? (AKA: Take a value that is returned in the User Tool in the Key field and select * from <view> where key='key_value' . ) Have you looked at the SQL and API logs from the server to see the SQL that the ARS server is actually issuing for the "broken" form? (It likely will tell you the most about what is going on.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 2/28/07, Simon Beckman <[EMAIL PROTECTED]> wrote:
I am trying to create a view form using ARS 6.3 and failing. Any help greatfully received. Here is the story.... There is a View in an SMS database that I want to bring into Remedy. I have created the Linked Servers (db are on SQL Server 2000) with no problem and created a view in the Remedy db using the following create view dbo.smstestview as select MachineID AS MachineID_SMS, Domain AS Domain_SMS, Name AS Name_SMS, SiteID AS SiteID_SMS from CGTSSMSM0001.SMS_UIT.dbo.Remedy_Test_View If I return rows from this newly created view in the remedy dB, I see all the data and columns. which is great. So now, into the Remedy Administrator tool and Create a new View Form. I enter the View Name and hit the Load button. I am then returned only one column from the view that I can select and this column is the Primary Key. If I select it and save the view form and then go into the Remedy User Tool and search on the new View Form, I see all the rows returned with just that one primary key field showing. So far so good-ish.... If I then try and go back to the View Form in the Admin tool and add another field, mapped to another column in the view and then save the Form, I get the error message stating "Cannot Create or Modify a data field without specifying a corresponding DB columnname. Please specify a valid DB column name (ARERR 2988)" I know the column is correct. Permissions seem ok too. So why cant I see those other columns and select them when creating the View Form? I have even created a Display Only field on my view form and written an AL that fires some Direct SQL to perform a select statement on the view and this works ! So permission dont seem to be the issue. Please can anyone shed any light on this. Many thanks, Simon.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
