It really depends on the 'kind of work' that you are having the server perform. A major factor to consider would also be, your environment. What kind of clients would be interfacing with the AR Server? Just your regular WUT or the MT client? Or would you be using web-services or a variety of other client types. With some client types other than the WUT or MT, it is important to understand that your client side workflow may not be supported. For these you might need to use Filters to do what an AL can although it may seem that an AL would be better...
If your environment is one where you have your users limited to the WUT or MT, then actions such as validations and data integrity checks for example, are better done on a client before the transaction is sent to the server, than having the server do it. So it really comes down to what you really need to get done, and where.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Jason Miller Sent: Friday, April 16, 2010 3:29 AM To: [email protected] Subject: OT: Extracting digits from a character field ** This might start a whole new debate (and kind of what I am looking to do)... I remember learning that train of though (use an AL to run on the client and use their resources when you can and built filters only when you have to) but I have started to hear the opposite over the last few years... Let the server do the work. I think part of it is that server are so fast now days and also with server groups you can have multiple load balanced AR server to share the load. With the move to all web clients, ultimately a server will end up doing the work whether it is an MT server or an AR server. We are people's thoughts on this? Jason On Thu, Apr 15, 2010 at 3:39 PM, cpgold <[email protected]> wrote: ** Does it have to be a filter, an active link is much better suited for this type of processing than to let the server handle it. On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza <[email protected]> wrote: I do not have access to an Oracle instance at the moment to try it, but I'm quite sure that update tablename set columnname = REPLACE('Does work', 'Does ', NULL); commit; would update the column to 'work'. Which is ideally what you would want it to.. With MS-SQL it sets the column to NULL. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 2:03 PM To: [email protected] Subject: Re: Extracting digits from a character field You mean works incorrectly. LOL. F Sent from my Verizon Wireless BlackBerry -----Original Message----- From: Joe D'Souza <[email protected]> Date: Wed, 14 Apr 2010 13:25:31 To: <[email protected]> Subject: Re: Extracting digits from a character field You are right, I just tried and it sets the whole column to NULL instead of just replacing the specific characters in expression 2 to NULL.. It works correctly in Oracle to the best of my knowledge.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 1:00 PM To: [email protected] Subject: Re: Extracting digits from a character field Replaciing a character with Null is an oxymoron in MS-SQL. You would replace a character with a zero-length string. Null and "" are not the same. Fluxman Sent from my Verizon Wireless BlackBerry -----Original Message----- From: Joe D'Souza <[email protected]> Date: Wed, 14 Apr 2010 11:42:21 To: <[email protected]> Subject: Re: Extracting digits from a character field Jim, Just curious.. What are the limitations that you encountered replacing a character or a string with NULL on MS-SQL.. And what version of MS-SQL?? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 11:12 AM To: [email protected] Subject: Re: Extracting digits from a character field On MS-SQL, trying to replace one character with Null is not a good idea. Fluxman ------Original Message------ From: Joe D'Souza Sender: Action Request System discussion list(ARSList) To: [email protected] ReplyTo: [email protected] Sent: Apr 14, 2010 11:07 Subject: Re: Extracting digits from a character field If you are in an Oracle database, use the function TRANSLATE to replace all Alpha characters with either NULL or space or whatever else you wish to.. This will leave the string with only special characters and numerical characters.. I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if MS-SQL is your underlying database. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Atul Vohra Sent: Wednesday, April 14, 2010 9:42 AM To: [email protected] Subject: Extracting digits from a character field I have a free form character field and need to extract digits from that field - may be in a filter? Am on v7.1, oracle. Any one has some function they used (like in sql or may be combination of strstr??) Looks painful to me. Help please Atul _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
