Comment in the code from the makeForeignKeyConstraint function in
DataGems.cal:
// TODO: make sure the fields are not specified backwards here...
They are :-)
It is specifying the fk components as (PKCOLUMN_NAME, FKCOLUMN_NAME).
Whereas if you read the specification in DatabaseMetadata, it says
they should be in the opposite order.
Can someone make sure Rich sees it (on Mon) ...
Thanks
-Steve
The problem has been fixed, and will be in the next OpenQuark release.
Thanks
Rich