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
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
