Would the test include a test of the Wizard's ability to implement this? The error first surfaced there.
-- Luc. On Friday, 30 November 2012 15:15:39 UTC, Richard wrote: > > Ask again when you are ready I have little app dedicated to check for this > issue. > > Richard > > On Fri, Nov 30, 2012 at 10:10 AM, Massimo Di Pierro > <massimo....@gmail.com<javascript:> > > wrote: > >> Correction. Not fixed. >> >> >> On Friday, November 30, 2012 9:10:30 AM UTC-6, Massimo Di Pierro wrote: >>> >>> Can you check trunk? I just submitted a patch that should have fixed >>> this problem. The price: slower table initilization but perhaps negligible. >>> >>> On Friday, November 30, 2012 8:51:06 AM UTC-6, Richard wrote: >>>> >>>> I open an issue in the pass about that. >>>> >>>> http://code.google.com/p/**web2py/issues/detail?id=382<http://code.google.com/p/web2py/issues/detail?id=382> >>>> >>>> Richard >>>> >>>> On Fri, Nov 30, 2012 at 8:50 AM, Anthony <abas...@gmail.com> wrote: >>>> >>>>> The format argument goes in the define_table() call -- is that where >>>>> you have it? >>>>> >>>>> Anthony >>>>> >>>>> On Friday, November 30, 2012 1:58:09 AM UTC-5, Luc Chase wrote: >>>>>> >>>>>> Thanks for the suggestion. I had tried something similar but got an >>>>>> error and even with this I have an error referencing to the unexpected >>>>>> use >>>>>> of 'format'. >>>>>> >>>>>> >>>>>> <type 'exceptions.TypeError'> __init__() got an unexpected keyword >>>>>> argument 'format' VERSION web2py™ (2, 2, 1, datetime.datetime(2012, >>>>>> 10, 21, 16, 57, 4), 'stable') PythonPython 2.7: C:\Program >>>>>> Files\Python\web2py_win\**web2py**\web2py.exe TRACEBACK >>>>>> >>>>>> 1. >>>>>> 2. >>>>>> 3. >>>>>> 4. >>>>>> 5. >>>>>> >>>>>> Traceback (most recent call last): >>>>>> File "gluon/restricted.py", line 212, in restricted >>>>>> >>>>>> >>>>>> File "C:/Program >>>>>> Files/Python/web2py_win/**web2py**/applications/Timesheet/**models**/db_wizard.py" >>>>>> >>>>>> <http://127.0.0.1:8000/admin/default/edit/Timesheet/models/db_wizard.py>, >>>>>> line 40, in <module> >>>>>> >>>>>> TypeError: __init__() got an unexpected keyword argument 'format' >>>>>> >>>>>> ERROR SNAPSHOT [image: help] >>>>>> >>>>>> <type 'exceptions.TypeError'>(__**init**__() got an unexpected >>>>>> keyword argument 'format') >>>>>> >>>>>> On Thursday, 29 November 2012 02:08:58 UTC, Massimo Di Pierro wrote: >>>>>>> >>>>>>> The problem is that it cannot assign the default validator unless >>>>>>> the table is defined. You can do >>>>>>> >>>>>>> db.define_table('t_project', >>>>>>> Field('f_name', type='string', >>>>>>> label=T('Name')), >>>>>>> Field('f_parent_project', type='reference t_project', >>>>>>> label=T('Parent Project')), >>>>>>> .... >>>>>>> format='%(f_name)s', >>>>>>> migrate=settings.migrate) >>>>>>> >>>>>>> db.t_project.f_name.requires = IS_EMPTY_OR(IS_IN_DB(db,'t_**pro** >>>>>>> ject.id <http://t_project.id>',format=db.t_**project._**format)) >>>>>>> >>>>>>> The last line will restore the dropdown. >>>>>>> >>>>>>> >>>>>>> On Wednesday, 28 November 2012 14:39:14 UTC-6, Jim S wrote: >>>>>>>> >>>>>>>> I'm seeing this as well. >>>>>>>> >>>>>>>> -Jim >>>>>>>> >>>>>>>> >>>>>>>> On Tuesday, November 27, 2012 12:09:18 PM UTC-6, Luc Chase wrote: >>>>>>>>> >>>>>>>>> If the reference is to a different table, the CRUD form renders >>>>>>>>> the field as a list box allowing the user to select the record from >>>>>>>>> the >>>>>>>>> foreign table. But as a self-join the CRUD form renders the field as >>>>>>>>> a >>>>>>>>> simple text box and it seems to create a default value of 0 when >>>>>>>>> saved. >>>>>>>>> Then, I think that causes the record to generate an error when viewed >>>>>>>>> ( but >>>>>>>>> not when edited). >>>>>>>>> >>>>>>>>> >>>>>>>>> I can post the entire models file if that would help. >>>>>>>>> >>>>>>>> -- >>>>> >>>>> >>>>> >>>>> >>>> >>>> -- >> >> >> >> > > --