This topic is locked

Required field * behaving weird

10/3/2005 5:53:46 PM
ASPRunnerPro General questions
author

Why is it that everytime I save a project and when I open the project again and make some changes and make a new build that some of the fields has the astrik that shows its a required field when in reality its not? You can still leave those fields blank and add stuff but its annoying having that Required field there. Any help would be greatly appreciated.
Thanks

Sergey Kornilov admin 10/3/2005

If in your database database some fields are defined as NOT NULL or "Do not allow zero length values" those fields will be marked as Required on ADD/EDIT pages.

C
Colzie 11/29/2005

If in your database database some fields are defined as NOT NULL or "Do not allow zero length values" those fields will be marked as Required on ADD/EDIT pages.



I am evaluating ASPRunner, and here is my problem:

I have a checkbox, and whenever it is selected, the Required icon is displayed next to it on the Add and Edit pages (after saving). When it is not selected, the icon is not displayed.
In MS Access 2000 I set the Data Type as "Yes/No" and set the Required field to "No" in the General tab. I do not have a "Do not allow zero length values" option when the Data Type is "Yes/No", only when it is set to "Text" (available options for "Yes/No" are Format, Caption, Default Value, Validation Rule, Validation Text, Required, and Indexed).
In the ASPRunner Formatting screen I set the "Edit as" to "Checkbox".
Any ideas?

Sergey Kornilov admin 11/30/2005

MS Access always marks Yes/No field as NOT NULL - that's why you see an asterisk next to checkbox.
We changing this behaviour in the next release of ASPRunnerPro. Only fields that are marked as required in ASPRunner will have an asterisk next to them.