how to creating record only if the record does not exist . What is the best approach ? I have a db , and using the create service to create the record - this works .
I have been trying to use database query service to query for the record and then call the create service only if the query returned has no records.
db query service always returns a success , just that the rows returned is empty or zero so cannot really use this for creating a record only when record does not exist .
Any suggestions? or perhaps an example would be helpful on how to use db create service to create a record only when a record does not exist .
Thanks