[web2py] Re: How to speed up query processing in web2py's sqlite?

2017-06-02 Thread Carlos Kitu
As Leonel mentioned, index creation will be your best friend in this issue. I have been using web2py during the last two years, and till now, I had no concerns about database performance because I was working in intranet applications without a big volume of data. In the latest project we had a

[web2py] Re: SQLFORM.grid change form vars

2017-06-02 Thread icodk
Dave S. I appreciate your responsiveness and alertness and the ever willingness to help others. Thanks On Friday, June 2, 2017 at 6:37:03 AM UTC+2, Dave S wrote: > > > > On Thursday, June 1, 2017 at 6:19:02 PM UTC-7, Dave S wrote: >> >> >> >> On Thursday, June 1, 2017 at 2:52:08 PM UTC-7, icodk

[web2py] smartgrid edit form javascript calculation

2017-06-02 Thread T.R.Rajkumar
In model I have this db.define_table('amc_details', Field('amc_id','reference amc_master'), Field('jcod', type='string',required='True',notnull='True',length=10),

[web2py] Re: SQLFORM.grid change form vars

2017-06-02 Thread icodk
Thanks I am a bit slow but I think I got it. On Friday, June 2, 2017 at 4:41:39 AM UTC+2, Anthony wrote: > > On Thursday, June 1, 2017 at 5:52:08 PM UTC-4, icodk wrote: >> >> Thanks, That explain why it didn't work in smartgrid (because I haven't >> specify the table name) >> I still do not

[web2py] Re: smartgrid edit form javascript calculation

2017-06-02 Thread T.R.Rajkumar
Sorry. I am able to do it. In view new_contract.html I have now this. {{extend 'layout.html'}} New Contract {{=form}}