Multiselect Listboxes

ksex948

Hi,

I am working with two listboxes that are initially getting populated from database tables (Access). They basically allow the user to transfer information back and forth from one listbox to the other listbox WITHOUT affecting the database.

My question is this. When the user selects <Save Changes>, I want to be able to update the database table with the information in Listbox1. Basically like a security setup utility. What's my best option?

My solution would be to store the original entries of Listbox1 in Array1, then once the use selects the <Save Changes>, store the new set of Listbox1 entries in Array2. Compare with some sort of looping routine. If more entries exist, do a SQL Insert. If less, do a SQL Delete.

These listboxes are very limited in methods and properties. They are specific to an SAP application software.

Thank you.

Sep 18 '07 #1

gits

hi ...

welcome to TSDN ...

could you please post some code you have so far? the idea to link the listboxes with js arrays sounds good ... but you may consider objects ... so you might optimize the runtime behaviour of the list-compare-operation. have a look at this article ...

kind regards

Sep 18 '07 #2