Hi to all, I'm new to the list and also to web2py (I started learning it a week ago). So first of all I must say Thank You to Massimo and to the community for such a great framework!!! Your work is much appreciated! Now back to my question. I've a database on a mssql server with some tables; i need to expose these tables to the internal lan so users can modify the records (please note I need to modify record already present in table and not create new ones). As you can image the structure of the tables is fixed (I can not modify it, no possibility to add id column) so I think I should use the keyed tables as exposed here [1] but as far as i can understand, update of record is not possible at the moment with keyed tables.
So my idea is: -define the legacy table in web2py (with migrate= False and primarykey) -use the SQLFORM helper to generate forms -do manually update using pyodbc Is this feasible? any suggestion or code example is welcome! Thanks! Pier [1] http://groups.google.com/group/web2py/browse_thread/thread/db150376b06d47fc/d8738e8ccecbaacb?lnk=gst&q=keyed+tables#d8738e8ccecbaacb
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
