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?
