Hi,
I'm trying to set a domain (TINYINT) to a min value of 1 and a max value of 99: https://www.screencast.com/t/zJI2tieP
How does this work in the background? I cannot find any references in the deployment source code and when I do an Update Model in app I can still fill in a value of 0 without getting any error.
Any ideas on what I'm missing here?
Best answer by Mark Jongeling
View original
+23
Hi Alban,
Using these min/max value field will result in an automatic DB Check constraint. After Generating definitions, you will see a Generated record in Data model > Tables > Check constraints.
That does mean the source code for Checks have to be generated and executed on the database.
If you want give a message to the user upon filling in the value, you will have to resort to using the Default procedure and using tsf_send_message to show the user a message upon exceeding the desired boundaries.
Hope this helps!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
