Just wondering if there is another way to save listbox item into a database.
The database is populated on a listbox. If I made some changes in that listbox, how to update the database.?
so far what I’m doin is, just drop the table then save it all the listbox item again into the database. This is working, but way to slow.
The item that I had in the database is only 2000 items, but it takes 30 second to process.
If i follow you correctly, you’re deleting the table entirely, re-creating the table and saving back the items from the ListBox. I haven’t got Xojo in front of me, so it’s from memory I’ve drafted the below code. In essence, after you complete an edit for a row, then add the below code to save only the row edited. Check the LR it should clarify the below code further. There are other ways to achieve this but this is for starters.
ps. The code above, effectively is a template, substitute your values.