Hi, Dave, Thanks for your reply, >Yes. This is the problem with MySQL not being able to initially defer the >constraints. If you need to use MySQL, I suggest that you remove the Foreign >Key constraint between STUDENT and PERSON in the database and trust that EOF >will keep everything correct for you. In my case PERSON is abstract class not TABLE in DB, do you mean remove the Foreign Key constraint between Address and Home_address? No problem with that sequence, problem is try insert STUDENT first instead of ADDRESS. If it's MYSQL issue, why it's working sometimes with correct generated SQL, like address, home_addres then student. If EOF, WOnder or somebody else have some code to check this order of the insert table name has the right sequence, that would be working.
>I would also suggest that you avoid using Vertical Inheritance if you can. It >is very inefficient when creating select statements in the database. It does >make the database more normalized, but at the cost of efficiency. In this >situation I would use Single Table Inheritance instead. I am just try to verify VI is working in EOF. Yes maybe need change to horizontal inheritance or Single Table Inheritance instead. thanks Xiaowen(Kevin) Ren Analyst Programmer Channel Applications, Retail Applications ANZ National Bank Ltd Level 6 ASB Tower 2 Hunter Street PO Box 1791 Wellington >Phone: 04 4365363 Fax: 04 8028696 "This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."
_______________________________________________ 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]
