[web2py] Re: Grid edit behavior when no changes are made

2017-08-04 Thread Dave S
On Friday, August 4, 2017 at 1:42:54 PM UTC-7, Seth J wrote: > > So, archives on this page: https://github.com/niphlod/web2py/releases > don't contain it?!?! > I'm not sure. I would expect the zip files to, but that's a dev's archive rather than the "official" web2py archive referenced in

[web2py] Re: Grid edit behavior when no changes are made

2017-08-04 Thread Seth J
So, archives on this page: https://github.com/niphlod/web2py/releases don't contain it?!?! On Friday, August 4, 2017 at 4:34:16 PM UTC-4, Dave S wrote: > > > > On Friday, August 4, 2017 at 1:17:08 PM UTC-7, Seth J wrote: >> >> Another quick question. How do I revert back to 2.14.6 or 2.14.5

[web2py] Re: Grid edit behavior when no changes are made

2017-08-04 Thread Dave S
On Friday, August 4, 2017 at 1:17:08 PM UTC-7, Seth J wrote: > > Another quick question. How do I revert back to 2.14.6 or 2.14.5 then? > I downloaded the appropriate version archive and replaced all of the files > in the installation and it still gives me the same error message: > If

[web2py] Re: Grid edit behavior when no changes are made

2017-08-04 Thread Seth J
Another quick question. How do I revert back to 2.14.6 or 2.14.5 then? I downloaded the appropriate version archive and replaced all of the files in the installation and it still gives me the same error message: Version web2py™ Version 2.14.5-stable+timestamp.2016.04.13.22.22.13 Python

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Seth J
Thanks, Leonel! Looking forward to it ... On Thursday, August 3, 2017 at 1:24:08 PM UTC-4, Leonel Câmara wrote: > > Seth that 2.15.2 bug has been fixed in trunk. Please wait for 2.15.3 > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Leonel Câmara
Seth that 2.15.2 bug has been fixed in trunk. Please wait for 2.15.3 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Seth J
And it appears to be broken: web2py™ Version 2.15.2-stable+timestamp.2017.07.19.12.18.41 Python Python 2.7.10: C:\Python27\python.exe (prefix: C:\Python27)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Traceback (most recent call last): File ".\gluon\restricted.py", line 219, in restricted

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Seth J
We're using 2.14.5 version of web2py so far. Let me update one of our dev servers and see if that solves the issue. Thanks, Anthony!!! On Thursday, August 3, 2017 at 12:30:11 PM UTC-4, Anthony wrote: > > Also, what version of web2py are you using? Looking at the code, it > appears this issue

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Anthony
Also, what version of web2py are you using? Looking at the code, it appears this issue might be resolved in the current version of the DAL (it now generates all the fields to be updated *before *call the _before_update callbacks, which should result in the archive record being generated due to

[web2py] Re: Grid edit behavior when no changes are made

2017-08-03 Thread Anthony
The problem is that archiving is handled via a _before_update callback, which (a) only receives the fields that are explicitly submitted with the form (i.e., not the modified_on and modified_by fields) and (b) archives only if the submitted fields differ from those in the original record. The

[web2py] Re: grid edit

2017-05-31 Thread T.R.Rajkumar
Yes Anthony, with this the grid edit is OK. [setattr(f, 'writable', False) for f in db. amc_master if f.name not in ['id', 'amcdesc', 'amcmod', 'complndays']] But how come it worked fine with postgresql without the id field setting? Anyway thanks a lot for resolving the issue. -- Resources: -

[web2py] Re: grid edit

2017-05-31 Thread Anthony
On Wednesday, May 31, 2017 at 5:39:11 AM UTC-4, T.R.Rajkumar wrote: > > When I do SQLFORM.grid(db.amc_master) without setting any of the > readable/writable attributes the grid edit works fine. I am able to edit > and the form submits without errors. > Even with specifying the fields list grid

[web2py] Re: grid edit

2017-05-31 Thread Jim S
Have you tried adding 'id' to your editable field list? [setattr(f, 'writable', False) for f in db.amc_master if f.name not in ['amcdesc','amcmod','complndays', 'id']] -Jim On Wednesday, May 31, 2017 at 4:39:11 AM UTC-5, T.R.Rajkumar wrote: > > When I do SQLFORM.grid(db.amc_master) without

[web2py] Re: grid edit

2017-05-31 Thread T.R.Rajkumar
When I do SQLFORM.grid(db.amc_master) without setting any of the readable/writable attributes the grid edit works fine. I am able to edit and the form submits without errors. Even with specifying the fields list grid edit works fine as the edit from has all the fields of the table. But when I

[web2py] Re: grid edit

2017-05-30 Thread Anthony
The "id" field is not writable in SQLFORMs, so the grid/SQLFORM do not include that field in update SQL queries. Does the "id" field actually appear as writable in your forms? What happens if you just do SQLFORM.grid(db.amc_master) without specifying the fields list or setting any of the

[web2py] Re: grid edit

2017-05-30 Thread isi_jca
T.R.Rajkumar Try setting this value: *field_id* must be the field of the table to be used as ID, for example db.mytable.id. This is useful when the grid query is a join of several tables. Any action button on the grid(add record, view, edit, delete) will work over db.mytable. Regards. --

[web2py] Re: grid edit

2017-05-30 Thread T.R.Rajkumar
I don't know why there is no response from anyone in the group. Is the post not clear? Thanks in advance. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) ---

[web2py] Re: grid edit

2017-05-25 Thread T.R.Rajkumar
I googled and saw this https://www.drupal.org/node/2342699 where it is stated that SqlContentEntityStorage::mapToStorageRecord sends update statements that includes IDENTITY fields that need to be updated, such as: UPDATE xxx SET nid = 1, property0 = :value0 WHERE nid = 1;. This is not

[web2py] Re: grid edit

2017-05-24 Thread T.R.Rajkumar
When I connect to postgresql the same model the grid edit form submits without error. Is this to do with pyodbc? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

[web2py] Re: grid edit

2017-05-24 Thread T.R.Rajkumar
I have this in model. db.define_table('amc_master', Field('amcno', type='string',length=10, required='True',notnull='True',requires=IS_LENGTH(10)), Field('unitid',type='string',length=3,notnull='True'), Field('amcdesc',

[web2py] Re: grid edit

2017-05-24 Thread Dave S
On Tuesday, May 23, 2017 at 11:28:29 PM UTC-7, T.R.Rajkumar wrote: > > Why is DAL trying to update id column in grid edit form submission. > I think we need your model file to have much idea. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: grid edit

2017-05-24 Thread T.R.Rajkumar
Why is DAL trying to update id column in grid edit form submission. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you