Subject | update on cascade |
---|---|
Author | Alberto Pesce |
Post date | 2006-04-27T19:39:11Z |
Hi all,
In Firebrid 1.5 is it possible use UPDATE ON CASCADE with the source value is not a primary key in source table
Source table
1000 ----------------
1002 ----------------
1022 ----------------
1056 ----------------
1000 ----------------
Table 2
150 365 1000
151 365 1002
152 365 1022
153 365 1000
In order that if I change a value 1000 to 999 in Source Table I obtain change also in Table 2?
How can I do that?
Thanks in advance
Alberto
[Non-text portions of this message have been removed]
In Firebrid 1.5 is it possible use UPDATE ON CASCADE with the source value is not a primary key in source table
Source table
1000 ----------------
1002 ----------------
1022 ----------------
1056 ----------------
1000 ----------------
Table 2
150 365 1000
151 365 1002
152 365 1022
153 365 1000
In order that if I change a value 1000 to 999 in Source Table I obtain change also in Table 2?
How can I do that?
Thanks in advance
Alberto
[Non-text portions of this message have been removed]