Joe: I never ran into that, but my first thought would be to enhance the source code of the ARDBC plugin to produce the desired behavior and recompile. I suppose you could just write your own plugin, also.
--Phil -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, April 06, 2012 09:27 To: arslist@ARSLIST.ORG Subject: Re: Column Sort on Vendor Form I recall this to be happening a long time ago too. I think it just never got fixed. Never tried that workaround though.. How would it work with ARDBC plugin related vendor form where the data is not actually stored in the form? Joe -----Original Message----- From: Murnane, Phil Sent: Friday, April 06, 2012 9:04 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Column Sort on Vendor Form Frank: I vaguely recall something like this happening to me years ago. The workaround was to get the DBA to change the database view to contain a space character when the data would have been null. If it's a numeric column, we asked the DBA to put zero instead of null. Maybe this would work for you? --Phil -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, April 06, 2012 08:59 To: arslist@ARSLIST.ORG Subject: Column Sort on Vendor Form ARS 7.6.04 sp2 Oracle / Redhat Created a vendor form using the ARDBC LDAP connection with about 30 fields. The form opens correctly (User Tool and Midtier) and I can run queries against it. I can also click on a results list column heading and sort the results. However, when I try and sort on a column where one of the result records has no value (NULL, empty string) value for the field being sorted the plugin crashes and I get this error: Cannot establish a network connection to the AR System Plug-In server : abcd-123 ARSYS.ARDBC.LDAP : RPC: Miscellaneous tli error - System error (Connection refused) (ARERR 8760) Anyone else seen this issue? Thank you Frank Caruso _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
