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"

Reply via email to