[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Tim Richardson
Solved. My bug. Process of recreating a minimal app revealed that the code which fetches data from a webservice was not doing what I thought. Thanks. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and sto

[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Tim Richardson
On Saturday, 4 May 2013 00:33:37 UTC+10, Anthony wrote: > > Hard to say what's going on. Just loading the grid doesn't do any writing > to the database, so something else must be happening. Can you produce a > minimal app that replicates this behavior with SQLite? Yes, it seems so. At least,

[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Anthony
Hard to say what's going on. Just loading the grid doesn't do any writing to the database, so something else must be happening. Can you produce a minimal app that replicates this behavior with SQLite? Anthony On Friday, May 3, 2013 10:15:43 AM UTC-4, Tim Richardson wrote: > > > > On Friday, 3 M

[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Tim Richardson
On Friday, 3 May 2013 23:59:51 UTC+10, Anthony wrote: > > How did the record get created to begin with? Did it start with a > cm_patient_id value of 0? Are you sure you committed your change when using > the database management tool? This works: I open up the grid in web2py, and click on the

[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Anthony
How did the record get created to begin with? Did it start with a cm_patient_id value of 0? Are you sure you committed your change when using the database management tool? Anthony On Friday, May 3, 2013 9:37:10 AM UTC-4, Tim Richardson wrote: > > > > On Friday, 3 May 2013 21:31:09 UTC+10, Antho

[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Tim Richardson
On Friday, 3 May 2013 21:31:09 UTC+10, Anthony wrote: > > Are you saying you do or do not want cm_patient_id in the grid? cm_patient_id is not shown on the grid, which is correct. Sorry for the poor post, I am using fields like so: fields=[db_vciadmin.web_form_1te.date_submitted, ...

[web2py] Re: SQLFORM.grid seems to overwriting an unshown field.

2013-05-03 Thread Anthony
Are you saying you do or do not want cm_patient_id in the grid? To restrict the fields displayed, the correct argument is "fields", not "Field". What do you mean when you say you "edit the table to put a value in cm_patient_id"? How are you doing that (presumably not via the grid, given that ed