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.
Written by Rajeev N Bharshetty
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Javascript
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#