Only the following data types are supported in view forms: DB2-varchar, varchar2, char, clob, integer, smallint, real, double SQL Server-char, varchar, tinyint, smallint, int, text, real, float, decimal Oracle(r)-varchar, varchar2, char, clob, number, float Informix-char, varchar, int8, smallint, integer, text, smallfloat, float, decimal Sybase-char, varchar, tinyint, smallint, int, text, real, float, decimal
The way I got around this is: I have access to an external database via a SQL View. We will call this view "remedy_view" 1. On that particular db; rename "remedy_view" to "remedy_view_temp". 2. create a dummy table with the same field names and make the field types ones that Remedy can recognize (see above). Call this table "remedy_view" 3. Create your view form. 4. Drop the dummy table 5. Rename your "remedy_view_temp" to "remedy_view". Hope this helps. Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Welton Bryant Sent: Thursday, June 10, 2010 11:18 AM To: arslist@ARSLIST.ORG Subject: Re: View Form Error? ** 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"_ _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"
