Thanks Joe! I guess I should have been a little more specific... I agree with your and Doug's point (See new thread: Logic in active links vs. filters) of always using Filters for logic/rules that you always want to happen. I was referring more to work flow processing that is not critical business rules and data integrity. There those times when doing development where you think for a moment, should this be a Filter or an Active Link. If it is a toss up which way is better?
Let's end the comments regarding AL vs Filter on this thread and reply to the a more appropriate thread "Logic in active links vs. filters". Jason On Fri, Apr 16, 2010 at 12:23 PM, Joe D'Souza <[email protected]> wrote: > ** > 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 >>> >> _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"
