I see that I need to have a unique column field that enforces not null and must
be an integer or char no less than 6 no greater than 15. The view nor the form
form doesn't have that column. Can I create a view and change the type of the
field to meet the requirement for remedy? Can I do like Create view
dbo.MyViewForm
AS
select
UID INT NOT NULL, as Field
, Last_Name
, First_Name
........etc
I only have read access to the table from the linked server and I just created
the view by select * from that table.
LJ Longwing <[EMAIL PROTECTED]> wrote: ** After a quick search through my
master index for 6.3, it told me that the information I was looking for was in
the 'Basic' guide, I found the information I was referring to starting on page
174. Good luck
---------------------------------
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of tricky maybe
Sent: Friday, May 23, 2008 8:21 AM
To: [email protected]
Subject: Re: No available columns when creating a view form from SQL
** Remedy 6.3 on SQL 2005. Which manual should I be looking for? Thanks
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of LJ Longwing
Sent: Friday, May 23, 2008 7:08 AM
To: [email protected]
Subject: Re: No available columns when creating a view form from SQL
**
Well Tricky,
There is a section in the manual, which manual depends on your version, that
tells you what field types are supported in Remedy View forms, if you don't
have any of those, then they won't show up as available fields, pay special
attention to the requirements for the Request ID field.
---------------------------------
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of tricky maybe
Sent: Friday, May 23, 2008 8:02 AM
To: [email protected]
Subject: No available columns when creating a view form from SQL
** I have a view on SQL that I want to load on Remedy so I open the admin
tool and click on new object then I select view form and type in my database
table ARSystem.dbo.MyViewForm and when I click on load I don't get an error but
there's no available columns showing up. MyViewForm is a view I created from a
linked server using SQL. I can query that view on SQL using management studio
with no problem. Do you know why I can't load it on Remedy or can someone show
me how how to do this? Thanks
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__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"
