Great! So is even easier to do than expected! (my fault to not double check what update_record does, sorry)
Once again Thank you! Pier On 21 Gen, 15:37, mdipierro <mdipie...@cs.depaul.edu> wrote: > So this works > > db(query).update(field=value,...) > > but this > > db(query).select().first().update_record(field=value,....) > > does not for keyed tables. > > thanks Denes for the clarification. > > On Jan 21, 8:20 am, DenesL <denes1...@yahoo.ca> wrote: > > > Hi Pier, welcome to the group. > > > I believe there is a slight misunderstanding probably generated by > > Note 5 in the referenced post: > > 5) update_record function is not available > > > update_record is a function used to update single records (objects of > > class gluon.sql.Row) and for technical reasons it is not available in > > keyed tables but all the other functions that apply to regular tables > > also work for keyed ones: update, insert, delete, ... > > and they behave almost the same way, the post shows the differences > > using examples. > > > Denes. > > > On Jan 21, 3:35 am, m3tr0 <pier.cart...@gmail.com> wrote: > > > > 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/db150376b0...
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
