They are all nvarchar fields. Welton Bryant MCSE,MCP
Lead Systems Programmer CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell welton.bry...@cts-sharedservices.com <mailto:welton.bry...@cts-sharedservices.com> www.caretechsolutions.com <http://www.caretechsolutions.com/> ________________________________ 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. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"