Free online database builder and html form creator for integrating form and database to page Gbflag_unactive Uaflag_unactive Ruflag_hover
Loading

Все посты
No duplicates database validation

No Duplicates option allows you to validate uniqueness of your columns.

Please, see below simple example of how to use this validation option

How to create simple database with validation No Duplicates

1) Create new project Validation Uniqueness
New project
2) Create new form Validation Uniqueness (Enter form name into the field)
New form
3) Add just one field to your new form "ID Number" with Number type
Validation
Under field you can see link Validation
 Field ID Number
4) You will see various validation options in the pop-up window. Check No duplicates
Validation window for number type
 
Validation window for number type
5) Then Add record link
7
6) Now you have first record with "777"
2
7) If you will try to enter another record with such value you will see Validation Uniqueness in action
3
This field have validation 'No duplicates', so you can add to database only one original record. Hope it helps!

Добавил пост andrew в 10-20-2009 13:01

Теги к посту: validation, uniqueness, news Share

Последний раз редактировано 07-25-2010 17:55

Пожалуйста, ввойдите в MyTaskHelper чтобы иметь возможность оставлять комментарии

 
Форум
Rss Twitter-logo Facebook-logo