I am trying to follow the Person/Address foreignkey example in the http://www.sqlobject.org/SQLObject.html#foreignkey
I am just wondering why the foreignkey constraint is not created on the Address table. The column person_id is created of course, but the foreignkey constraint is NOT set (I am checking this using IBExpert tools). Is this intentional?
BTW I have found two problems (errors??):
when: person = ForeignKey('Person', cascade = 'null')
than, when I am trying to delete rows from the Person table (see example bellow), I am getting this error:
"(-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL error code = -104\n Token unknown - line 1, column 33\n NULL')"
File: /usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/dbconnection.py, line: 329
when: addresses = SingleJoin('Address')
print p1.addresses throws following:
"class FirebirdConnection has no attribute 'limit_re'"
File: /usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/firebird/firebirdconnection.py, line: 120