Dear Mr.Massimo!, Thank you very much for your quick response. I am presently using web2py version 1.99.7(download url: http://www.web2py.com/examples/static/web2py_win.zip). You are right that something else is causing the problem. Now i can not perform any operations(insert,edit,delete or update) on any of the tables. Something mysteriously has frozen the whole model. I tried dropping a few fields from the table, they do get dropped.But no crud takes place on the database. I suspect that i had deleted the files in the databases folder of my application since sqllite does not issue alter command if i change a few field definitions(like adding unique constraint). But they did get created again when i changed the model.
I hope you can help me find a way out of this! Yours Sincerely, Rahul Priyadarsi. On 9 June 2012 20:08, Massimo Di Pierro <[email protected]> wrote: > 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? >> >
