can "simulate" the "UPSERT". :)
Thanking in advance.
Regards,
Tan Shao Yi
- Original Message -
From: Heikki Tuuri
Date: February 16 2004 9:12am
Subject: Re: REPLACE INTO and CASCADEs.
Hi!
The REPLACE + FOREIGN KEY behavior indeed changed between 4.0.17 ->
;Tan Shao Yi" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 14, 2004 10:29 PM
Subject: REPLACE INTO and CASCADEs.
> Hello,
>
> I just upgraded from 4.0.17 to 4.0.18 on a Linux box and realised the
> behaviour of REPLACE INTO appears to have changed.
>
&g
Hello,
I just upgraded from 4.0.17 to 4.0.18 on a Linux box and realised the
behaviour of REPLACE INTO appears to have changed.
I have two tables: table2 references table1 with ON DELETE CASCADE and ON
UPDATE CASCADE on a primary key.
Previously in 4.0.17 when I issued a REPLACE INTO on table1,
