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.
add new comment
Author of the question about filed sizes for Number Data type fields.
Your blog is my favorite, congratulates. Often I'll look here, a lot of information and nice site. Tom Davis