You may have better luck with NOT EXISTS. Axton
On Mon, Jun 8, 2009 at 5:08 PM, LJ Longwing<[email protected]> wrote: > It may work, if I was familiar with the minus command...:)....I'll hafta > read up on that one :) > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Grooms, Frederick W > Sent: Monday, June 08, 2009 3:33 PM > To: [email protected] > Subject: Re: Creating the "two tables with the add/remove buttons in between > to swap data between tables" effect > > LJ, Wouldn't that be something like: > > SELECT description FROM left > MINUS > SELECT description FROM right > > That should give you unique values on left that are not in unique values > from right > > Fred > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of LJ Longwing > Sent: Monday, June 08, 2009 3:33 PM > To: [email protected] > Subject: Re: Creating the "two tables with the add/remove buttons in between > to swap data between tables" effect > > I would do it slightly different. > > Left would be a join of Left and Right...the join would be something like > > SELECT left.description > FROM left, right > Where left.description not in ( > select right.description > from right > ) > > And the table on the right would be just a regular display of what's on the > right > > The SQL above isn't tested...and more sudo code than actual...but should > work depending on your db and version. > > Then when you add from left to right, refresh both tables...the item you > just added to the right should be removed from the left, and vis versa if > removing from the right. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Thad K Esser > Sent: Monday, June 08, 2009 2:22 PM > To: [email protected] > Subject: Re: Creating the "two tables with the add/remove buttons in between > to swap data between tables" effect > > Curt, > > You have two tables: > Table A is on the left, with "A.Value" referring to what's showing in the > list. > Table B is on the right, with "B.Value" as the values. > > Create an unlimited length, temporary character field (zTmpChar). > > Any time Table B gets changed (don't forget window open if appropriate), > call a guide that walks the B table (make sure the table is refreshed > first), and sets the zTmpChar field to a list of the B.Values. Use whatever > you want as separators, I'll use semi-colons here (if you make sure the list > starts and ends with semi-colons, things are easier). In your screenshot, > after the table walk, the zTmpChar field would look like: > ;eBiz Catalog;eBiz eCommerce;Engineering Tools; > > Set the table qualification on Table A to be: > NOT($zTmpChar$ like "%;" + 'A.Value' + ";%") > > Refresh Table A. > > The "tricky part", if you will, is to put the zTmpChar field to the left in > the LIKE clause, and have the Table A value on the right. > > Its been a while since I did this and I don't have access to that code > anymore, so hopefully I remembered enough to be helpful. > > Thad Esser > Remedy Developer > "Did you ever wonder why we had to run for shelter when the promise of a > brave new world unfurled beneath a clear blue sky?" - Pink Floyd > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Schryver, Curt > Sent: Monday, June 08, 2009 2:28 PM > To: [email protected] > Subject: Creating the "two tables with the add/remove buttons in between to > swap data between tables" effect > > Has anyone come up with a means to replicate this functionality in AR? > The > list on the left needs to be dynamic. Once an item has been selected and > "moved" to the right, it should no longer appear in the left side. See > image for a better example of what I mean. > > http://arsystem.comxa.com/2tables.jpg > > ARSystem 7.0.01 patch 3 > Windows 2003 Server > Oracle 10i > > Thanks, > Curt > > Curt A. Schryver > Action Request System Administrator > Tyco Electronics > 100 AMP Drive > MS 161-043 > Harrisburg, PA 17105 > 717-810-2109 tel > 717-810-2124 fax > [email protected] > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:[email protected] ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
