2. ASPRunnerPro General questions
  3. All fields required fields
This topic is locked

All fields required fields

 		12/18/2003 2:43:07 PM
ASPRunnerPro General questions
J
 jsober author

I am using asprunner 2.4 (dled 12/17/2003), although I get the same problem in 2.3. Using an Access 2000 DB through ODBC (with current mdac), all fields in the database are teated as required from asprunners edit and add pages. There are no fields marked as required (except for the key field) in my database, and only the key field shows the "required field" icon on the asprunner edit page (although when generated in 2.3, all fields show up with the icon).
Is there a variable that I am not finding (I do not know vbscript/asp but am familiar enough with scripting languages that I can find my way around) that I can manually edit or is this a known problem that is currently being worked on?
Thanks to anyone who can advise.
Jeff Ober
admin 12/18/2003

Jeff,
open your table in design mode and MS Access and set Allow Zero Length to Yes for each field that you like make not required. In other case it will be displayed as required (because MS Access don't allow to insert empty values into these fields).
I hope this helps.

Sergey Kornilov
J
 		jsober author 12/19/2003

Thanks. That worked fine. Should have figured it out myself <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=841&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Jeff