Avoid Duplicate Elements to be Inserted into database

If you want to avoid Duplicate elements to be inserted into database ,

1 ) Query the database with the value as ( In Titanium Mobile Javascript )

var rows = dbHandle.execute('select * from shoppingList where shopping_name = ?', editText.value);

2 ) And if rows.getRowCount == 0 , then insert that value into database.

else

Show a notification that a duplicate element already exists.