In the past I have used a combination of unique data that exists in the form to 'generate' a unique ID...the unique ID is really for update purposes...if your view form is going to be used solely for 'select' operations...the uniqueness of the request ID is less important (or so I have found)
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Tricky Sent: Friday, May 23, 2008 8:57 AM To: arslist@ARSLIST.ORG Subject: Re: No available columns when creating a view form from SQL ** I was able to create a view from the external database but the problem is that view does not have a field that is required to create a view form on Remedy. How can I specify the type of field when creating a view using SQL? Thanks From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Friday, May 23, 2008 7:45 AM To: arslist@ARSLIST.ORG Subject: Re: No available columns when creating a view form from SQL ** If you are attempting to create a view form from an external sql database... For SQL Server- TABLENAME or DATABASENAME.OWNER.TABLENAME (Make sure you specify dbo if the current user is the owner of the table.) Also make sure ARAdmin has permissions to the sql db you are attempting to create a view form with. Syntax - [INAME\INAME].DBNAME.OWNER.TBNAME This is the syntax for SQL 2005 with an instance name, the instance name is in the brackets [INAME\INAME] You can test it by the following sql query- select * from [INAME\INAME].DBNAME..OWNER.TBNAME Is this what you are looking for Tricky? Kevin P. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"