I have run into this issue before when trying to read external databases.. I wonder why there is a limitation to the fields ARS can read ??
Marcelo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 10, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to select desired "key field" for View form ** Check your field types... From the "Integrating with Plug-ins and Third-Party Products" Doc 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 You may have to make a db View that converts the db table fields to a supported type and use that for your View Form. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Renjini Johney Sent: Wednesday, March 10, 2010 12:47 PM To: arslist@ARSLIST.ORG Subject: Unable to select desired "key field" for View form ** Hi All, I am trying to create a view form on a data base table , when i put the table name in "Database table" field and click load, it automatically shows 6 fields in the "key field" (i have 80 fields in the table) I want to choose an another field (not fromthe 6) as key field, but its not allowing me to do so :(, Can someone help with this issue??? -- Regards, Renjini _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
