MySQL and Foreign Keys
MySQL and Foreign Keys
- Subject: MySQL and Foreign Keys
- From: Doug Andrews <email@hidden>
- Date: Wed, 23 Mar 2005 11:01:08 -0500
Is there a way to get EOF to order database operations when using MySQL?
Basically, here is the problem:
Table A has a 'to one' relationship with table B.
I want to add a record to both tables within the same transaction, but
if i cannot control the order of database operations, i will get a
foreign key constraint error.
FrontBase has the "DEFERRABLE INITIALLY DEFERRED" option for your
foreign keys that would solve this problem.
There does not seem to be an option like this for MySQL.
Does anyone know how to deal with this issue when using MySQL?
- Doug Andrews
- Baseview Products
- Ann Arbor, MI
- email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden