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"
