On Tue, 27 Apr 2004, Glenn MacGregor wrote:
> Now I need to change the parentname field (in the case of vimid = 2)
> from [EMAIL PROTECTED] to test and keep the vimname field as is. When I do
> this the constraint no longer works (which makes perfect sense).
>
> 1 | [EMAIL PROTECTED] | cell | f |
Sorry for being too vague. Here is my exact situation.
I have the following table currently:
Table "xpressvim"
Column| Type |
Modifiers
-++---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I am using a cascade delete on the following table:
> ...
> So the delete cascade states if I am deleting a row whose vname
> matches the parentname delete those rows and it works fine.
> ...
> This works, so I tried to put that in the cascade bu
Hi All,
I am using a cascade delete on the following table:
vid vname parentname
1[EMAIL PROTECTED]
2[EMAIL PROTECTED] [EMAIL PROTECTED]
3[EMAIL PROTECTED] [EMAIL PROTECTED]
4[EMAIL PROTECTED] [EMAIL P