Unique Database index Field
Posted: Sat Jan 18, 2014 8:05 pm
How can you stop duplicates in the Database? I know that I would need both a server side script but I am at a total loss as to how to go about it?
Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
How can you stop duplicates in the Database? I know that I would need both a server side script but I am at a total loss as to how to go about it?
Hello Willie,
Please tell us in more detail what exactly you would like to do? Please tell us in more detail what exactly you would like to do? Post a screen shot. What index fields are duplicated?
Hello, I have a Database with Truck Numbers in it I am trying to insure that no duplicate truck numbers are entered into the database. But there is no way to set the data field at Unique
Hi Willie,
You would need to create a service for reading this data. If there is no such record - add it.
Trying to do the same .... how do I know if there are no records ?
Do I assume if the query succeeds it means there are records and failure means record is not present ?
Hi Shawn,
You can check a length of service response on service Success event. If it equals 0, then nothing is found:preif (data.length === 0){
alert("not found");
}/pre
that worked. thanks katya !