Hi,
my previous developer uses the following constraits in the xfm which is confusing me ..pl help me to understand this .
the the following two links.none of them are rejected..
link constraint
fromfilter ('I'=toFilter.UPDT_TXN_TYPE_CD) or ('D'=toFilter.UPDT_TXN_TYPE_CD)
todelete ('D'=toFilter.UPDT_TXN_TYPE_CD)
thanks
constraint confusing
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
the values of toFilter.UPDT_TXN_TYPE_CD are either I or D
as you said if the value of toFilter.UPDT_TXN_TYPE_CD = D then the rows has to go to the link todelete, but couple of rows with D are showed up at the next xfm(fromfilter link) and here his is deleting records from the table if the value is D
as you said if the value of toFilter.UPDT_TXN_TYPE_CD = D then the rows has to go to the link todelete, but couple of rows with D are showed up at the next xfm(fromfilter link) and here his is deleting records from the table if the value is D
Yes. "I" or "D" goes down the first link, only "D" goes down the second. In other words, an "I" goes down the first link and a "D" goes down both.
Interesting they were written what would generally be considered to be 'backwards'... but either direction gets you the same results.
Interesting they were written what would generally be considered to be 'backwards'... but either direction gets you the same results.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom