2. PHPRunner General questions
  3. Make field required
This topic is locked

Make field required

 		1/8/2005 20:08:51
PHPRunner General questions
author

Is it possible to mark fields as required??

I have some fields that (pPrice) that I would like to force when users add/edit data.
.. very impressed thus far <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1003&image=1&table=forumtopics' class='bbc_emoticon' alt=':P' />
501124 1/8/2005

whoops... just found it :-)
501125 1/8/2005

Umm, I found it but in order to make it required I seem to have to define its type through "EDIT AS" but when I look at the database structure through phpmyadmin I have pPrice set up as DOUBLE and some others such as int, varchar etc
How do these relate to the options available in the Edit As drop down??
ps.. I'm new to mySQL so forgive me if its a stupid question <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3031&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Sergey Kornilov admin 1/12/2005

Paul
If you want to make field pPrice required, then select to edit it as Text field and check off Required checkbox. Also you can specify Validate as: Number to prevent users from entering non-number values.
Edit as type defines edit control appearance. There is no direct correlation between database type and Edit as type.