This topic is locked

Not Null columns

2/28/2005 4:01:36 PM
PHPRunner General questions
S
sgeggie author

I have a MySQL database with several "Not Null" columns.....however they are not showing up as required fields.
I recently downloaded the trial software again, hoping that it might contain some fixes.....This is when this problem appeared.
If this is the issue, where do I find the most recent stable version?
Thanks

admin 3/2/2005

Hi,
Database fields that have not null attribute shouldn't be assumed as required. They behave differently in some cases.

I.e. not null fields accept empty string values while required fields not.
I would recomend to make these fields required on the Formatting tab in PHPRunner by specifying its Edit as type and then checking off Required in Edit format dialog.
The most stable version of PHPRunner can be found at

http://www.asprunner.com/files/phprunner-setup.exe

S
sgeggie author 3/2/2005

In My SQL, I already have types setup for ENUM and SET. When I try to make these required, the software asks me to retype the values. If I don't try make them required or use edit formats, the field renders as a drop down with all my enumerated values.

admin 3/4/2005

Hi,
Set Edit as type to Lookup wizard in PHPRunner and add list of values manually. Then you can mark this field as required.
Also you can edit include/..._functions.php file (function IsRequired) to make this field required.