Try varchar2 then.. I am not 100% sure if MS-SQL server supports varchar or varchar2 but if varchar doesn't work it has to be the other.. I know for certain nvarchar doesn't work.
If varchar2 doesn't work as well, then you probably are addressing the wrong table or view? Is that table or view remote? Or is it local to the AR System database.. If it is local, then log in the MS-SQL client and type sp_help followed by the table or view name which will give you the structure of the table. Verify the structure is good and valid as far as the AR System requirements are concerned.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Welton Bryant Sent: Thursday, June 10, 2010 2:23 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** I put a ticket in with Remedy to find out if this is a bug. It didn't work for varchar either. Welton Bryant MCSE,MCP Lead Systems Programmer CareTech Solutions Inc. ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, June 10, 2010 2:15 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** It may be a documentation bug then? Did it work when you changed the data type to Varchar? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Welton Bryant Sent: Thursday, June 10, 2010 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** Thanks for the help. The 7.5 integration guide book (page174) I have said Sqlserver nvarchar is supported but apparently it is not..... Thanks for all the help! Welton Bryant MCSE,MCP Lead Systems Programmer CareTech Solutions Inc. ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, June 10, 2010 1:43 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** Welton, nvarchar is not supported by the AR System for any of the databases to the best of my knowledge.. Its either varchar or varchar2 or both. For MS-SQL specifically I think its varchar that is supported... If you can change the structure of the original table to match the data types that the AR System supports, you will get it working. There should be a matrix of supported data types in the admin guide in the section that discusses view forms against SQL views or tables.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Welton Bryant Sent: Thursday, June 10, 2010 12:18 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** They are all nvarchar fields. Welton Bryant MCSE,MCP Lead Systems Programmer -------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, June 10, 2010 12:05 PM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** I know this seems basic, but have you verified they are of types that Remedy recognizes in view forms? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Welton Bryant Sent: Thursday, June 10, 2010 9:43 AM To: arslist@ARSLIST.ORG Subject: View Form Error? ** Hello all, I am creating a sql View form and can't figure out why I am getting an error when trying to connect to the SQL database. Keep getting an "ARNOTE 5165 There are no columns in the table." There are plenty of columns in the table and they can be access using the same permission on the physical SQL server. Any suggestions on how to correct this? Thanks. ARS 7.5 P4 SQL 2005 Welton Bryant MCSE,MCP Lead Systems Programmer CareTech Solutions Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
