Do you have to let the user do that copy/paste because they add result to
kind of empty CSV/Excel spreadsheet to feed your system or you only want to
move data around once?
In later case you can make a request at DB level or in web2py shell...
Richard
On Tue, Feb 7, 2012 at 3:48 PM, Omi Chiba <ochib...@gmail.com> wrote:
> 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...
>
>
