I just tried this and it works fine with me. I only had to change the
compute field:
Field('Amt_Outstanding',compute=lambda r: (r.Net_Due or 0)-(r.Amt_Paid
or 0))
to avoid errors when Net_Due or Amt_Paid are blank.
What web2py or python version do you use? I suspect something else is
causing the problem.
On Saturday, 9 June 2012 01:01:25 UTC-5, rahulserver wrote:
>
> Hi!
> I have the following table in my model:
> db.define_table('Transaction_Master',Field('Account',db.Account_Master,requires=IS_IN_DB(db,'Account_Master.id',
>
> '%(Account)s %(State)s',zero=T('choose
> one'))),Field('Exam_Date','date'),Field('Entry_Date','date',default=request.now),Field('C35Hindi','integer',default=0),Field('C35Marathi','integer',default=0),Field('C35Gujarati','integer',default=0),Field('C35English','integer',default=0),Field('C35Oriya','integer',default=0),Field('C35Telegu','integer',default=0),Field('C35Kannada','integer',default=0),Field('C35Punjabi','integer',default=0),Field('C35Bengali','integer',default=0),Field('C68Hindi','integer',default=0),Field('C68Marathi','integer',default=0),Field('C68Gujarati','integer',default=0),Field('C68English','integer',default=0),Field('C68Oriya','integer',default=0),Field('C68Telegu','integer',default=0),Field('C68Kannada','integer',default=0),Field('C68Punjabi','integer',default=0),Field('C68Bengali','integer',default=0),Field('C912Hindi','integer',default=0),Field('C912Marathi','integer',default=0),Field('C912Gujarati','integer',default=0),Field('C912English','integer',default=0),Field('C912Oriya','integer',default=0),Field('C912Telegu','integer',default=0),Field('C912Kannada','integer',default=0),Field('C912Punjabi','integer',default=0),Field('C912Bengali','integer',default=0),Field('CSHindi','integer',default=0),Field('CSMarathi','integer',default=0),Field('CSGujarati','integer',default=0),Field('CSEnglish','integer',default=0),Field('CSOriya','integer',default=0),Field('CSTelegu','integer',default=0),Field('CSKannada','integer',default=0),Field('CSPunjabi','integer',default=0),Field('CSBengali','integer',default=0),Field('C35','integer',default=0),Field('C68','integer',default=0),Field('C912','integer',default=0),Field('grad','integer'),Field('Schoolwise_Form','upload'),Field('Schoolwise_Form_Name'),Field('Hath_Ghari','integer'),Field('Lekhan_Pad','integer'),Field('Geometry_Box','integer'),Field('College_Bag','integer'),Field('class3_5T','integer',default=0),Field('class6_8T','integer',default=0),Field('class9_12T','integer',default=0),Field('gradT','integer',default=0),Field('Amt_3_12','integer'),Field('Amt_grad','integer'),Field('Pr1','integer'),Field('Pr2','integer'),Field('Gross_Due','integer'),Field('Net_Due','integer'),Field('Amt_Paid','integer',default=0),Field('Amt_Outstanding',compute=lambda
>
> r: r['Net_Due']-r['Amt_Paid']),format='%(Account)s %(Exam_Date)s')
>
> When i try to insert a value into it using either database
> administration(admin interface) or thru sqlform, i am not able to insert
> the data. When i flash the form.errors in sqlform, i get the following
> :<Storage{}>
> What could be the reason?
> Is there a limit to the maximum number of fields in a table in sqllite? If
> so then what could be done apart from splitting the table?
>
