On Apr 10, 2007, at 2:12 PM, Chuck Hill wrote: Is the join between the two correctly defined? Turn on SQL logging and see what it is trying to do to fetch these.
Apparently not:
[2007-04-10 14:22:13 PDT] <WorkerThread0> === Begin Internal Transaction [2007-04-10 14:22:13 PDT] <WorkerThread0> evaluateExpression: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT t0."creationDate", t0."description", t0."eoid", t0."imageEoid", t0."lastModifiedDate", t0."title" FROM "PANEL" t0"> [2007-04-10 14:22:13 PDT] <WorkerThread0> 2 row(s) processed [2007-04-10 14:22:13 PDT] <WorkerThread0> === Commit Internal Transaction
Ok, so the relationship is defined thusly:
Name images Cardinality To One Optionality Optional Delete Rule Cascade Model LicensePlate Destination PanelImages Inner
And then in the table below that I have image_eoid from Panel and eoid from PanelImages listed.
That is all under the Basic tab of the Properties pane. I didn't enter anything in the Advanced or User Info tabs.
Also, I had thought that everything was working on my save because data appeared in both tables, but I just checked in FrontBase Manager and confirmed that image_eoid in Panel is null, so the root of the problem is that that is not being written properly.
janine
|