Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Location
    Sydney, Australia
    Posts
    58

    Unanswered: Limit the maximum value in a number field

    When setting up the properties of a field, what is the expression for limiting the numbers which can be entered to <=9?
    The number entered in this field must be 9 or less but not null.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    This is not possible with MySQL as it does not support check constraints.

    The only workaround is to use a trigger.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •