On Apr 10, 2007, at 2:36 PM, Janine Sisk wrote:

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.


OK, now we are getting somewhere. How are you connecting the create PanelImage with the Panel? Are you connecting it? If it is not an owned object you need to tell WO which object it belongs with.


Chuck

--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects





_______________________________________________
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]

Reply via email to