[web2py] Re: Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
Anthony, the basic recommendation was to use SQLFORM.factory, and that was a good idea. I tried it again and i had now more success than some weeks before. So now i can insert rows in the table "book" and the table "verb" in one FORM and with only one submit-button. The FORM looks like this: fo

[web2py] Re: Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
Antony, thank you, i tried exactly this some weeks ago and it did not work. Since now... may be, that i worked not enough. I will try more and we will see.

Re: [web2py] Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
I have also constraints on database level, but this is necessary for normal logical consistency of the database model. The problem is for me again - even if i use that "reference" or "list.reference" - that i cannot have * ONLY* these fields book.title author.name in my form on the screen and *

Re: [web2py] Many-to-many relations with CRUD Insert

2012-01-17 Thread Christian Winterhager
Yes, thats clear. Until now i use a program, which is based on INFORMIXDB with Python und CGI. In this program (respectively programs) i do exactly that what you described above in your mail. It is not difficult to write these programs but it is slow and boring. But now i know web2py and i wan

[web2py] Many-to-many relations with CRUD Insert

2012-01-16 Thread Christian Winterhager
One of the standard examples of many-to-many Relations is a library. For simplicity i choose only 3 Tables: db.define_table ('author', Field ('name', 'string', length=100)) db.define_table ('verb', Field ('bnr', db.book ), Field ('anr', db.author ), ) db.define_table ('book',