Thanks Massimo,
It both works.
My objective is to find the difference of last 2 entries. But I preferred
to use the last you given below.
But my problem is, it always use the first row to compute the difference.
Thanks for your reply.
On Sunday, June 23, 2013 2:55:53 PM UTC+3, Massimo Di Pierro wrote:
>
> rows = db(db.test).select(limitby=(0,2))
> rows[1].update_record(t2 = rows[1].t1-rows[0].t1)
>
> or if you need it for all records:
>
> row0 = db(db.test).select(limitby=(0,1)).first()
> db(db.test).update(t2 = db.test.t1-row0.t1)
>
>
>
> On Sunday, 23 June 2013 01:42:30 UTC-5, Tribo Eila wrote:
>>
>> Hi,
>>
>> Supposed a model:
>>
>> db.define_table('test',
>> Field('t1', 'integer'),
>> Field('t2', 'integer'),
>> )
>>
>> How to find the difference in db.test.t1 (ex: db.test.t2(row2) =
>> db.test.t1(row2) - db.test.t1(row1)) and store the result in db.test.t2.
>>
>> What approach should i used? Thanks.
>>
>
--
---
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.
