Yes it can - the table I'm trying to create is perfectly valid and sensible (and it works fine if implemented directly in postgres or mysql). I'm just having trouble representing it effectively with the DAL.
On 18 February 2013 18:54, pbreit <[email protected]> wrote: > Can a reference be optional? > > > On Monday, February 18, 2013 12:19:04 AM UTC-8, Paul Whipp wrote: >> >> Here is an example of what I need to do: >> >> db.define_table('Docket', >> Field('Docket_No', 'integer', >> required = True), >> Field('Reference_Docket_ID', 'reference Docket', >> required = False), >> Field('Reference_Docket_No', 'integer', >> required = False), >> ... >> >> The docket optionally refers to a preceding docket in the model. It >> appears that web2py's DAL ignores the required = False specification for >> this field because when I use the SQLFORM it tells me that 'Reference >> Docket_ID' is a required field so its impossible to enter any docket >> records. >> >> The client database is postgresSQL >> >> I tried adding the field constraints (e.g. db.Docket.Docket_No.requires = >> IS_NULL_OR(IS_IN_DB(...))) >> but then it fails to display the dropdown when the form is presented. >> >> With hundreds of tables, I don't want to have to craft the form by hand. >> >> I'm also wondering what happens when there are many thousands of dockets >> - will the dropdown for the Reference_Docket_ID on the form cope >> effectively? >> >> Cheers, >> Paul >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
