Jason, since you are using SQL 2005, try to use row_number() function in your select query. This function will generate sequential row numbers for each record and in return you may use it in request id field. Hope this will work because I never tried it in SQL 2005. In oracle I often use rownum function to trick the Remedy.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Tricky Sent: Friday, May 23, 2008 8:21 AM To: arslist@ARSLIST.ORG Subject: Re: No available columns when creating a view form from SQL ** When I hit load nothing shows up on the available columns list. The reason for that according to the manual is because the database view must contain an integer or character field that enforces no null value and unique to act as the request ID field and I don't have a column(field) that meets that requirement on my database view. I do have a field that is unique that I can use how do I change the type of that field to enforce the no null value? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Friday, May 23, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: No available columns when creating a view form from SQL ** Here is a screen shot. You will need to select one of the columns as a designated Key field. 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"
