In your tutorial for Defining Tables and Field Sizes point 6 reads:
"6. Field Size It refers to the maximum length of data that can be stored inside this field. E.g., if you specify a number field size as 3, then it can store values maximum of 3 digits values or up to 999. Field sizes can be set for both text and numeric fields.)
Is this correct when dealing with a field data type of "Number". I cannot put 3 in the field size attribute.
What is the proper way of limiting a number data type field to 3 digits ie from 1 to 999? Eg Employee Payroll numbers from 1 to 999.
In your tutorial for Defining Tables and Field Sizes point 6 reads:
"6. Field Size It refers to the maximum length of data that can be stored inside this field. E.g., if you specify a number field size as 3, then it can store values maximum of 3 digits values or up to 999. Field sizes can be set for both text and numeric fields.)
Is this correct when dealing with a field data type of "Number". I cannot put 3 in the field size attribute.
What is the proper way of limiting a number data type field to 3 digits ie from 1 to 999? Eg Employee Payroll numbers from 1 to 999.
2 comments
Reply