Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect
Right you are. Some days the brain doesn't work as good as others. I tend to (always) go for the options that should never break. Axton On Mon, Jun 8, 2009 at 4:40 PM, Thad K Esser wrote: > I agree that InstanceIDs would be better, however my code wouldn't break > unless the values themselves had semi-colons in them. > > ;eBiz; > wouldn't overlap > ;eBiz eCommerce; > (note the semicolons at the beginning and ending of each value in the list > - as well the role they play in the qualification). > > But yeah, use the instance ids if you have them available (or make 'em > available). > > 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 > > > |> > | From: | > |> > >--| > |Axton > | > >--| > |> > | To: | > |> > >--| > |arslist@ARSLIST.ORG > | > >--| > |> > | Date: | > |> > >--| > |06/08/2009 02:27 PM > | > >--| > |> > | Subject: | > |--------> > >----------------------| > |Re: Creating the "two tables with the add/remove buttons in between to swap > data between tables" effect | > >--| > |> > | Sent by: | > |> > >--| > |"Action Request System discussion list(ARSList)" > | > >--| > > > > > > This one is almost there. It will break when you have values in the > table that are substrings of other rows or values in the table that > are the same value as other rows. > > Try adding this to Thad's response: > - Add a hidden column in the table for the instanceid for both tables > - Store the list of values in the char field as described (but store > the instanceid for each record, not a text value); > - create a new display-only field to store an external qual (qualfield) > - parse the semi-colon separated list of values and generate a > qualification, e.g.: > '179' = "guid1" OR '179' = "guid2" ... > > Set the left table to use External Qual: NOT(EXTERNAL($qualfield$)) > Set the right table to use External Qual: (EXTERNAL($qualfield$)) > > You will need to set the qualfield to "1=1" if it gets set null. > > The one limitation is that the qual can only be 4k chars on Oracle. > Not sure of where clause limits with SQL Server and others. Assuming > a 30 char instanceid and the overhead of the rest of the qualification > (14 chars), you will be limited to a selection of ~90 items. > > If ARS supported using IN, the list could be longer at ~121 items. > > You could opt to use the entry_id instead of the instanceid, which > would buy you more selections (1
Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect
You may have better luck with NOT EXISTS. Axton On Mon, Jun 8, 2009 at 5:08 PM, LJ Longwing 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:arsl...@arslist.org] On Behalf Of Grooms, Frederick W > Sent: Monday, June 08, 2009 3:33 PM > To: arslist@ARSLIST.ORG > 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:arsl...@arslist.org] On Behalf Of LJ Longwing > Sent: Monday, June 08, 2009 3:33 PM > To: arslist@ARSLIST.ORG > 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:arsl...@arslist.org] On Behalf Of Thad K Esser > Sent: Monday, June 08, 2009 2:22 PM > To: arslist@ARSLIST.ORG > 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:arsl...@arslist.org] On Behalf Of Schryver, Curt > Sent: Monday, June 08, 2009 2:28 PM > To: arslist@ARSLIST.ORG > 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 > cschry...@tycoelectronics.com > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect
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:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Schryver, Curt Sent: Monday, June 08, 2009 2:28 PM To: arslist@ARSLIST.ORG 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 cschry...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect
I agree that InstanceIDs would be better, however my code wouldn't break unless the values themselves had semi-colons in them. ;eBiz; wouldn't overlap ;eBiz eCommerce; (note the semicolons at the beginning and ending of each value in the list - as well the role they play in the qualification). But yeah, use the instance ids if you have them available (or make 'em available). 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 |> | From: | |> >--| |Axton | >--| |> | To:| |> >--| |arslist@ARSLIST.ORG | >--| |> | Date: | |> >--| |06/08/2009 02:27 PM | >--| |> | Subject: | |> >--------------------------------------| |Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect | >--| |> | Sent by: | |> >--| |"Action Request System discussion list(ARSList)" | >--| This one is almost there. It will break when you have values in the table that are substrings of other rows or values in the table that are the same value as other rows. Try adding this to Thad's response: - Add a hidden column in the table for the instanceid for both tables - Store the list of values in the char field as described (but store the instanceid for each record, not a text value); - create a new display-only field to store an external qual (qualfield) - parse the semi-colon separated list of values and generate a qualification, e.g.: '179' = "guid1" OR '179' = "guid2" ... Set the left table to use External Qual: NOT(EXTERNAL($qualfield$)) Set the right table to use External Qual: (EXTERNAL($qualfield$)) You will need to set the qualfield to "1=1" if it gets set null. The one limitation is that the qual can only be 4k chars on Oracle. Not sure of where clause limits with SQL Server and others. Assuming a 30 char instanceid and the overhead of the rest of the qualification (14 chars), you will be limited to a selection of ~90 items. If ARS supported using IN, the list could be longer at ~121 items. You could opt to use the entry_id instead of the instanceid, which would buy you more selections (137, or 222 if ARS supported IN sql token), the key here is to use a unique value to represent the selection of each record. Failure to adhere to this will result in breakage at some point. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 8, 2009 at 3:22 PM, Thad K Esser wrote: > Curt, > > You
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:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, June 08, 2009 3:33 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Schryver, Curt Sent: Monday, June 08, 2009 2:28 PM To: arslist@ARSLIST.ORG 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 cschry...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect
This one is almost there. It will break when you have values in the table that are substrings of other rows or values in the table that are the same value as other rows. Try adding this to Thad's response: - Add a hidden column in the table for the instanceid for both tables - Store the list of values in the char field as described (but store the instanceid for each record, not a text value); - create a new display-only field to store an external qual (qualfield) - parse the semi-colon separated list of values and generate a qualification, e.g.: '179' = "guid1" OR '179' = "guid2" ... Set the left table to use External Qual: NOT(EXTERNAL($qualfield$)) Set the right table to use External Qual: (EXTERNAL($qualfield$)) You will need to set the qualfield to "1=1" if it gets set null. The one limitation is that the qual can only be 4k chars on Oracle. Not sure of where clause limits with SQL Server and others. Assuming a 30 char instanceid and the overhead of the rest of the qualification (14 chars), you will be limited to a selection of ~90 items. If ARS supported using IN, the list could be longer at ~121 items. You could opt to use the entry_id instead of the instanceid, which would buy you more selections (137, or 222 if ARS supported IN sql token), the key here is to use a unique value to represent the selection of each record. Failure to adhere to this will result in breakage at some point. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 8, 2009 at 3:22 PM, Thad K Esser wrote: > 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 > > > |> > | From: | > |> > >--| > |"Schryver, Curt" > | > >--| > |> > | To: | > |> > >--| > |arslist@ARSLIST.ORG > | > >--| > |> > | Date: | > |> > >--| > |06/08/2009 12:28 PM > | > >--| > |> > | Subject: | > |> > >--| > |Creating the "two tables with the add/remove buttons in between to swap > data between tables" effect | > >--
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:arsl...@arslist.org] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: arslist@ARSLIST.ORG 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 |> | From: | |> >--- ---| |"Schryver, Curt" | >--- ---| |> | To:| |> >--- ---| |arslist@ARSLIST.ORG | >--- ---| |> | Date: | |> >--- ---| |06/08/2009 12:28 PM | >--- ---| |> | Subject: | |> >--- ---| |Creating the "two tables with the add/remove buttons in between to swap data between tables" effect | >--- ---| |> | Sent by: | |> >--- ---| |"Action Request System discussion list(ARSList)" | >--- ---| ** 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 cschry...@tycoelectronics.com _Platinum Sponsor: rmis
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 |> | From: | |> >--| |"Schryver, Curt" | >--| |> | To:| |> >--| |arslist@ARSLIST.ORG | >--| |> | Date: | |> >--| |06/08/2009 12:28 PM | >--| |> | Subject: | |> >--| |Creating the "two tables with the add/remove buttons in between to swap data between tables" effect | >--| |> | Sent by: | |> >--| |"Action Request System discussion list(ARSList)" | >--| ** 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 cschry...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmi
Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect
The move must modify a field that will eliminate the entry from the first table and then refresh the first table. -Original Message- From: Schryver, Curt To: arslist@ARSLIST.ORG Sent: Mon, 8 Jun 2009 3:28 pm 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 cschry...@tycoelectronics.com ? ? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"