what is the difference between field level an record level validation rule
Answers
Answered by
11
Field level controls how the data can be enter in a database field.
Record level controls how the data can be enter in a record or row of data in a database table....
Record level controls how the data can be enter in a record or row of data in a database table....
Answered by
11
Field level validation rule controls how the data can be entered in a database field(column)
Record level controls how the data can be entered in a record or row of data in a database table.
example: suppose you have a field called 'student_phone_number'
then the validation rule wud be 'only 10 digits allowed.' this will be valid for all entries in this field.
if you have a field called 'marks'
then the record validation rule wud be 'less than 100 & more than -1'.
Record level controls how the data can be entered in a record or row of data in a database table.
example: suppose you have a field called 'student_phone_number'
then the validation rule wud be 'only 10 digits allowed.' this will be valid for all entries in this field.
if you have a field called 'marks'
then the record validation rule wud be 'less than 100 & more than -1'.
Similar questions
English,
7 months ago
English,
7 months ago
Computer Science,
1 year ago
Science,
1 year ago
Social Sciences,
1 year ago
History,
1 year ago