Thanks for the clear explanation, Mike. Sadly this demostrate that I may have badly choosen the instrument. I'm building a mask to edit tables, possibly views of different tables, I want people be able to add filtering conditions on any field, issue the query, get the result and possibly edit it if reasonable.
I can do all of this for 1 table, a join (user->city ie: many2one) but you are showing this is not possible for one2many relations (not in one shot). I will study better the mapper built with .outerjoin or .innerjoin. Do you confirm that when I set values of Join instances (referring to the wiki example) I can only update the primary table of the join? sandro -- Sandro Dentella *:-) e-mail: [EMAIL PROTECTED] http://www.tksql.org TkSQL Home page - My GPL work ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

