I seem to be having problems getting my head around the default argument to
Field.
I am using SQLite as the backend.
If I do:
Field('grade_date','date',default=request.now,required=True,notnull=True)
I get a database column with a DEFAULT of todays date, not what I want:
grade_date DATE NOT NULL DEFAULT '2010-08-27'
If I do not include the default argument in the initial define_table but add
it
later todays date shows up in the form but there is no DEFAULT added to the
column.
What I would like to do is pass the SQLite date variable CURRENT_DATE to the
table. At this point I am unclear as to whether default is associated with the
table or the form.
Thanks,
--
Adrian Klaver
[email protected]