Mark, Spot on! I worked on it last night where I identified this issue.
Thanks, Terje ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: 19 September 2011 16:16 To: arslist@ARSLIST.ORG Subject: Re: Creating view form - only data type decimal and int visible ** Unicode AR server? If so, then the columns in the table will need to be nchar and so on. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue Sent: 19 September 2011 15:32 To: arslist@ARSLIST.ORG Subject: Creating view form - only data type decimal and int visible ** I am having some problems creating simple view form on MS SQL 2005. When I load the table only data type decimal and integer are available. Columns of Char, Text are not accessible. I have tried to connect to a few other tables and only data types decimal and integer are visible. I am connecting as database owner. This is not remote. The table holds plenty of columns. Where only data type int and decimal is visible in Developer Studio. Any tips? ARS 7.6.04, Windows Server 2008, MS SQL 2005. ~ Terje _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"