How to check duplicate value into a listbox before saving into DB

General
1

Hi guys

Maybe somebody has already answered my question , but i want take the chance to ask again:
"How to check a duplicate value into a listbox before saving into DB ?

Thanks to all

2

Or don’t bother, and just put unique constraints on the database table, and let IT tell you…
otherwise sort the data and check the current element against the one you just entered

3

Hi Dave

Many thanks

4

Make a sort on a specific (meaningful) column, then compare Row 0 to Row 1, Row 1 to Row 2 and so on ?

5

Loop from 0 to myListBox.ListCount -1, checking if myListBox.Cell(row, column) = valueToInsert is true. If it is, then Exit and don’t insert the new row. If not found, then insert the value.

6

I’m with Dave on this. Let the DB do it for you.

7

Use a ListBox to just display the Data. Store it somewhere else. Maybe in a SQLite DB in Memory.
Then follow Dave’s advise. :wink:

8

Hi guys

Thanks to all for your help & support.