Unique Database index Field

[Willie Sims]

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?

[Alena Prykhodko]

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?

[Willie Sims]

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

[Kateryna Grynko]

Hi Willie,

You would need to create a service for reading this data. If there is no such record - add it.

[Shawn]

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 ?

[Kateryna Grynko]

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

[Shawn]

that worked. thanks katya !