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.
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.
Comment