On Wed, Nov 21, 2007 at 11:07:01AM +0100, Bert Wesarg wrote: > Note, the only difference is the name of the second table. but in the > second case the table 'bla_person' is not created.
SQLObject sorts RelatedJoins tables alphabetically to avoid creating the same intermediate table twice... and doesn't found any RealatedJoin in Bla table... it doesn't look into Person because Person comes after Bla, where in the first your example Person comes before Role. RelatedJoins have to be mutual: class Person(SQLObject): name = StringCol() roles = RelatedJoin('Bla') class Bla(SQLObject): name = StringCol() persons = RelatedJoin('Person') Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss