For example, I have two tables, "request" and "result". I want user to
download all open request (status="1") from "request" table and upload
with the result to "result" table.
What's the easy way to do ?
db.define_table('request',
Field('subject'),
Field('status', default="1"),
Field('result))
db.define_table('result',
Field('subject'),
Field('result))
Only thing I can think of is...
1. delete result table
2. Select request table with (status="1") and insert them to the
result table
But I'm on AS400 located in Japan and this additional insert process
takes too much time for me. The best way is download the selected data
with the header of result table...