Ryan, what I meant is that it all depends of your DB, you can set a
constraint on MySql on non-innoDb .. it will be ignored as well as a
START TRANSACTION on MyISam ..
On Apr 14, 3:41 am, Ryan Schmidt wrote:
> On Apr 13, 2011, at 20:24, francky06l wrote:
>
> > Foreign key has nothing to do with i
On Apr 13, 2011, at 20:24, francky06l wrote:
> Foreign key has nothing to do with innoDB, but transaction has ...
Sure it does. Transactions and foreign key support are both features you don't
have in MySQL unless you use the InnoDB engine.
--
Our newest site for the community: CakePHP Video
Foreign key has nothing to do with innoDB, but transaction has ...
3 solutions:
- save current data before saving and roll back yourself (costive)
- accept the integrity potential defect, have a "batch job" to control
and correct
- have a transactional DB
On Apr 11, 6:56 pm, "Mariano C." wr
My DB server doesn't support innodb engine, so I can't use Foreign key
costraint.
How can I assure referential intergrity? Can I do this using cakephp,
how?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.ca
