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" >> > > _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"
