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, ...
> 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 editable is False)?
I meant that I am editing in directly via the database management tool (in
this case MS SQL Management Studio) . I am doing this to try to understand
what is going on.
In the production app, the edit of cm_patient_id is done with an SQLFORM
like so:from_date = request.vars.from_date_date = request.vars.to_date
def match_patient():
row_id = request.vars.row_id
#get the record
web_form_record = db_vciadmin.web_form_1te[row_id]
query = db_ps(db_ps.cm_patient.surname.contains(web_form_record.surname
)) #this subsets the values sent to the dropbox
db_vciadmin.web_form_1te.cm_patient_id.requires = \
IS_IN_DB(query, 'cm_patient.id', '%(surname)s, %(first_name)s DOB:
%(dob)s',zero=T('choose one'))
form = SQLFORM(db_vciadmin.web_form_1te,record=web_form_record)
.
.
.
(match_patient is setup in the SQLFORM.grid using links= )
So I am mucking around a bit with the requires definition in the model.
However, the database value is reset in the controller which shows the
grid. It is not reset simple because a new request occurs, as far as I can
tell.
>
> Anthony
>
> On Friday, May 3, 2013 4:15:26 AM UTC-4, Tim Richardson wrote:
>>
>> I must have missed something.
>>
>> In 2.4.6
>>
>> I have a MSSQL table with an integer field. When I show the table with
>> SQLFORM.grid, one of the fields is being reset to 0.
>> The definition of this field is
>> Field("cm_patient_id","integer")
>> The table is migrate =False.
>>
>> the SQLFORM.grid is
>> form = SQLFORM.grid(db_vciadmin.web_form_1te,deletable=False,
>> user_signature=False,editable=False,Field=[...]
>>
>>
>> but cm_patient_id is not one of the fields in the Field.
>> If I edit the table to put a value in cm_patient_id, I see that when the
>> SQLFORM.grid controller executes, cm_patient_id is reset to zero.
>> Driving me crazy. Seems a bit odd, and certainly unexpected.
>>
>>
>>
>>
>>
>>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
