Stephen... Didn't you mean the datatype VARCHAR2 ?? I haven't tested it with VARCHAR but I think its not a supported datatype.. VARCHAR2 is...
Simon... the new field you are creating, are you sure you are specifying the correct field name in the Database tab?? If not you can try selecting the field by right clicking on your view form and choosing the first option on the menu that appears on right clicking which will list all the available fields on the view form... Cheers Joe ----- Original Message ---- From: "Heider, Stephen" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, February 28, 2007 2:29:59 PM Subject: Re: Help with View Form Simon, What are the data types in the base table(s) of the SQL View? Try CASTing them to VARCHAR. If that doesn't work then add RTRIM or LEFT(fld, 255) to the colums. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Simon Beckman Sent: Wednesday, February 28, 2007 6:31 AM To: [email protected] Subject: Help with View Form 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. ____________________________________________________________________________________ Don't get soaked. Take a quick peak at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
