ios6 - how to check for an existing data in sqlite database in ios -


hi new sqlite database environment. created table few fields , make 2 fields unique. so, have show alert user while he/she inserts duplicate data table. can tell me "how check existing data before can inserted table in sqlite database"

you have query input data entered user , check whether present or not,

like fire query select count() category categoryname='usertext'

obviously know check data name of table(category in case i.e. in above query) , column name(categoryname).

if count more zero,data exist,you can alert user

else not exist.


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -