AFTER Delete Trigger question

AFTER Delete Trigger question

am 18.06.2010 16:03:44 von Kevin Labecot

--Apple-Mail-16-62397596
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=iso-8859-1

Hi,
Is there a way to update the same table on a delete trigger ?

I need to call an UPDATE statement when a delete occurs.

Best regards

--=20
Kevin Labecot, Innovantic
www.innovantic.fr
T=E9l. : 05.56.45.60.54




--Apple-Mail-16-62397596
Content-Type: multipart/related;
type="text/html";
boundary=Apple-Mail-17-62397596


--Apple-Mail-17-62397596
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=iso-8859-1

-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; =
">Hi,

Is there a way to update the same table on a delete trigger =
?

I need to call an UPDATE statement when a =
delete occurs.

Best regards

apple-content-edited=3D"true">
color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; =
font-style: normal; font-variant: normal; font-weight: normal; =
letter-spacing: normal; line-height: normal; orphans: 2; text-align: =
auto; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; ">
break-word; -webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; ">
break-word; -webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"color: rgb(67, 117, 254); font-family: Arial; font-size: 12px; =
line-height: 13px; -webkit-text-decorations-in-effect: underline; =
"> color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; =
font-style: normal; font-variant: normal; font-weight: normal; =
letter-spacing: normal; line-height: normal; orphans: 2; text-indent: =
0px; text-transform: none; white-space: normal; widows: 2; word-spacing: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; ">
break-word; -webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space; "> style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; ">
break-word; -webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space; ">
-- 
style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: medium; font-style: normal; font-variant: normal; =
font-weight: normal; letter-spacing: normal; line-height: normal; =
orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; =
widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; ">
Kevin =
Labecot, Innovantic
T=E9l. =
: 05.56.45.60.54

height=3D"40" width=3D"189" id=3D"bf46b9df-b332-45ea-bd9d-206b8df6f1be" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:50111781-53DF-44DA-8741-23B3A2D181CB">


=
>
n>

=

--Apple-Mail-17-62397596
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename=logo.gif
Content-Type: image/gif;
name="logo.gif"
Content-Id: <50111781-53DF-44DA-8741-23B3A2D181CB>

R0lGODlhvQAoAOfFAPErAPIxAvMyAPM2AfM3AfI4AfQ5AfI6BfQ8AfM7DvM+ AfU+B/Q/BnReUPRD
AfJGEPVMA/NKHXxoWvhNAPRNDfZRAvhUAPVVC4VwZPhYAIVxZPdXH/ZXMvZb DPldAfVcKPdgC/ll
AI16bo17bvdmDvlpAflqBflrAfhrD/dpJvZqQ/VrPfhvD/9vAJWEePhyKf90 B/t4Hv56Ep2Ngfd5
TJ6Og/R6Ufl9KP+ACPiBMP6FGfmEOP+IBKaWjKaXjf+IJfWHXq6glq6hl6+j jvuURv+XJrClj/+b
GLKmkvaYcLSplv6gGv6dOrWpn7eqofqeU/+hRfCfibium/6nJfmhdvGiirqx nf2mVr2zqb20or6z
qsC0rP+tPsC2pvuraPGrlsC4p8K6qfqthv6yTMa8rP+ybMW9rca8tP61V8e9 tMe9tfq0e8i/t/i1
kMjAscjBssnAufq2ksnCtPm5lv69Y/K6pcvEtfu7hfe8kczFt/68f/q7ms7F vc/Gvs7Huc/Hv8/I
vNDIwdDKvv7DffvBodLLwPfFn9TNwf7FltXOxPvGqtbPx9XQxPfJptfQye3M vdjRyv7Ll9jSx//L
nfzKsNnSzNnUye7PvvzMtP7OotrVy9zXzf/Rqt3YzvHUwt7Z0N7Z0fvTut/Z 0t7a0fTYxP/Xtf3X
wu/a0P7ZtPbbyP3axf3dyf/fvfbgz/3h0P7ixP/lzP/nz/f5+vr5+Pr7+/37 +vz8+/v9/f79+v39
/f/9+/3+/v/++/7+/v7+///+/v/+//7//v7//////v////Lv6vLv6vLv6vLv 6vLv6vLv6vLv6vLv
6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv 6vLv6vLv6vLv6vLv
6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv 6vLv6vLv6vLv6vLv
6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6vLv6iH+GkNy ZWF0ZWQgd2l0aCBH
SU1QIG9uIGEgTWFjACH5BAEKAP8ALAAAAAC9ACgAAAj+AP/9a2UIj8GDCNu0 aSSw4b9Qc9ognGgw
lcOLGDNq3Mixo8ePIEOKHHnRS4mTKFGe8DAhBp5/xGIKi/mQSAULJU6kTEmE pM+fQIMKHdoQz06V
ISZ48OKKV8xfxIAFi0nsH6EXSnUeNfGEqNevYMOCzHH0ZIYJREzBpMqWLa9/ a1iG0JrSREM4DSQU
Esu3L0hNEhrsvYhXL1AWR0NUiIFpbdvHVP+tepLBQ1mL/wI3GOG3s+eLNRps xqiZ80/EKT2YuPMP
KuTXkTHd8BBiJymBpT/r7qxBdAPSok37RF3CA4gnrmrF7AW7ObB/d1BkqH3y 9j82eQPt3i62t2iM
2CX+aD9dIkSGG40hz/o3q9dUYb9+rf+X6zEwV088eNBpnbv/7r7xxUIIFvQU 01RU0fLPJ4n8Q4su
AhEjzD+JQCKQa8T0whx0tIXQ338gEuXdb2KxkEEMrkjoyzAx1fLPKIII0omD /9AxyD++CMQIIJJE
SEwwGlZ1hQUeCrRFdg4JMdo/gYQmmg+VXFRJb1sI5IRmGjixkRMu+NaAE1E6 5MOSGFF5kRMjePnl
eEku2aRvUIqppmg1NHSkeBltMaZvQrCBEQoWrIFLWwIJ4ocmDtI0BhdrTfhP IX5Y8o8tbYVCggfW
5daQb044MWcDfjakZF7/jOibcA0FotmcdQpUiW/+VV60pwYNefqpaEJcxKmt aob6z60kZhaclGl+
6sJFlyqSYWSJCCIpTAIF8w8ajEoLky0CFbKXLszRdEMG1vlG66aimeqlBHKW e6uWqQIr2rG4vQtc
A61i524DbP6q7qfoCrSnmrkKJO5Fq36KKgkgYMLWPzsy4tgrR3Ay7Rj/lDIF KjNVpYkgey28A7gC
l+uQmuyqymlD/zbggoX/OElqQyPWwPIWq7L770VHihbqv+wK5HLAIZ/MZM0O jYjRwA11Gdx4bIzY
M8KULByjIJv8syEaPHAxxRRjZA1TL/9sUkiMjlX1sSdBjxt0A7FaCSfKSDe0 aq2+wdsQJL71G4j+
0D6LLNDe+B4tL7mitf0Prz4UHaCufv+Dd+MwP9kQ1FJrskkegIwCLSdL8MDD EZNA+48geVRdyCYI
VpWDBWjr24DarvfbruT+8i2Q0sG6nG/forGsNOy2Z4Rm3SOLJvvfb0f+HeOv ixq84xJowPI/IICg
bGR+0De6HXvdUhUnmfwzzC2P2iHIpP8AgnpkL7CedvFkCvRH8v/8q8ZFuCsf rEO8xppzA39w28sw
soUrzclurkPVP+ZHO4EYjXlqc5kjPgKCDlyPJnlYS9j8IIce1YcYufiHJOzg h6rR5FCp+0f7Whc3
1yFwgfT7VwAdkj8HLg5nfNNMwIqVOIeooVj+t0Ig8RzCwAb00IbLg5/aauiR Cl6PRf+wA0xmMqFE
pMEOnxDIKOzghgZRsSqRSp0rXlABFkJuiA0p4hFliL8bPvBMvtEC3UjlCN9M cI670hIaXXgRNSou
iYRboh0/0oEOECImUJRiVV4BE1lE0QxveIMZpCiLqpQCWnmQhBjJaMbmCUQU e/xHH2Lomz60UTSi
4F0DTAmaQX7SN2oY1QvFdUfC2Q2Ug2vIKBtYqhsG0nmi6VlD6tgAoHXgAocE Rkw64QaYoEIHPwid
tPIgBzlIcUKI0AEOOFEVOyQCQ65IQRnf98pcCmSXRoSbaFiZNN+k8h9aCCUx B8i7GmhGjg3+UQOf
4DiscqrsIug8Yi8BSc5/6BNySFTbMQ/5o6qEAVqIIAIOoBCLqpjBDJ0gRiyY gIMnhM6imyCGa8IJ
gU6qDZf/dEhA1bnKUzbgnQOl1zu1QDSVqul4/0hD3tIgEEekTHYofeFKGwJE nirxj5thZR+AaMwL
7IEts9CcTP7BhBZAQSBveKguoNCCIoiPJjNiyypSUNKCBhWgpFynS2E6zyBm BIhfmtecJFBUfwqV
fi37VCpb2NZPwe4CFXgqW3JRC2EI4xVXwAEOdBALWuSBDALRJg6YgDFh2IJS YiXrJeIVP9+0qiEo
BdqoGrAIWflSlObyrEbiabyMoNNLIxD+BUp7plqHhNamczKlpnRZMNjC9B8X oIBg28ILRMgABnoo
gw5eIQs3QPYfOihDJnQAgyv8I2OZdcBm4ZkXdh7udaW9iJI0AFNRpAloDVlE b4RZK9x9ybsYGZVR
MbKIf7kAnzndDEw9pYHwtom8F0kDEEeAz3hKAL5Wcq8Q5tuQC0BgDpD5xxN+ wApi6EEGzHXDQ/8h
gzL4IhZXYAIsILOKD2g3RChO8UeCG4cIM1JCZZBBLGRhhi5E1gsYeo0qTLxd Ffv4xwKhAARaDBlh
0II5mdCDQMyQBZhEIhMxmcUudMxjIFtZxRRwgBheMwtLIIpFVXGDFRyzHofp eAMn/gf+KPjgEFD4
Nyhu7gubhcKHN6N4zhRAABDA3JZc+GEIcqCPRcdME0AYAbKPmQkhHpDmJjTg DA1pwgt/Imm+8GF/
PllEA4LgY1BgIMgI2IAqXvMPMgzBCoewmhnG/A9NZGEITSY1DRDggEcIxNGy q/SVL3LpofABFD4+
wwyC7AACrKBsC7OEFJBABkmAwQqMkIMSlJBqYvCZKr+gAgMUUOtbu0AEPfC2 QLAQGBfY+QwYaAAG
II0FTv9jEcdq9z9cAOx/CPvd6V73P7Dggn67wN0CgTeusfCPXsM7aaVtQrnt 7BBJgwIULmhCENRd
2jO4gN8pXcQM3lVafoe30vDOSxP+Cu7vfr+5CSP/BwUUoIABfIAQUBFGt5bz D2krQQpWmDZkMfuj
YChTGK6wwQJorQBb/0PSmmZzpfkggdL2QAQEG3kToK7rXldaBCmfQbglQHBy P5wPfHB0ygVy6XBj
oQFr/k2vBVZn0v5jBgDHiAh+cwaRi/0fE1/3xtksAa6fQQKfvvTIBZ8ZEQi7 AWBH+cZx6oI5P4Dl
CCgAA2iwCl5glyrr6YIUpJAFRCW6KlSIAAEQwPKii7sJn670DGYA9ku/GQMz gLS4C/6bSk9dYGdA
feux3hBw8xrtAsF6r9f+q19vmuG6OtbEB9+Akc894Yh3NMGPjvhfjdwFn544 pAn+/+6+2/nTAnl8
6REwgAckAdmYb8hT2DKhPXyAAAYoPcuNrmsRBKHS2C/5mzUu8qPDy+rHAgqk RW5HJwElN30zAHW/
lzRNMHzBUn1nMHf6lhGE1yW3Vn0NoIAWaIECMXFshgEX1wAE517NFy8MZzcP gAAquIIEEAAc0AbX
1RzsxwuYQAMFIAArmIP0938qcyxa1xD1ll7jRlpVV3vwYn8uEG6oB4S3JgFB 2BDEhwFY4ICbwmbh
FQQ4FWmP9isaqHabJjBQx4H/gAH9koAgeDuY9g9zN30OsQhj9wAGEIdyiAAG AAACoAKKgH4kBgQP
YId0KIdxWAA72BATdyx/p3T+xyOABHdpoOB1b2eEtzZ3kAYKEsB8fFB3c/Z7 ZocuvSaAkOZofEBu
CQd+mSgQG+dmX5gZqbeFmmZ2DdADfLBxKedobrdvrxiLUDd3sPhrG/EBgCiH BWAAAgAACWADpnAg
bIEg/xB6AAAABhCMv2gABxBpCHSGBZiBdoYF+YaA6uZo/icQAig7fLCN86Ym DnFpecdma4eFXFd9
WIiNtHcRGPBpZ0dwAhhuPQB89Xhr+TZ26NhwgSECi6BpXsKG/9ADbPgFA0AA DNmQDFkAA9CMEXB+
j8ELe8ABAQAAAVAADtmRQLBrG0F8PzFsIJkRSXAAA5CSKpmSDDmMLigGjoE6 CSqQABrJkCt5kzZQ
khohkj5hkDrZEKdQB1UwlERZlEMZBVXwBXWwlEdplE75Ba3zkxcBCmMnlUMR EAA7

--Apple-Mail-17-62397596--

--Apple-Mail-16-62397596--

Re: AFTER Delete Trigger question

am 18.06.2010 16:39:51 von joao

------=_NextPart_000_0054_01CB0EDA.F67D3050
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0055_01CB0EDA.F67D3050"


------=_NextPart_001_0055_01CB0EDA.F67D3050
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

As far as I know, you can=B4t change data on the same table in triggers.

"Kevin Labecot" escreveu na mensagem =
news:4D2CE38B-D169-478B-AEBF-C19F20DCE4CC@labecot.fr...
Hi,
Is there a way to update the same table on a delete trigger ?


I need to call an UPDATE statement when a delete occurs.


Best regards


--=20
Kevin Labecot, Innovantic
www.innovantic.fr
T=E9l. : 05.56.45.60.54

=20


------=_NextPart_001_0055_01CB0EDA.F67D3050
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



http-equiv=3DContent-Type>



style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space"=20
bgColor=3D#ffffff>

As far as I know, you can=B4t change =
data on the same=20
table in triggers.

face=3DArial>
"Kevin=20
Labecot" < href=3D"mailto:kevin@labecot.fr">kevin@labecot.fr> escreveu=20
na mensagem href=3D"news:4D2CE38B-D169-478B-AEBF-C19F20DCE4CC@labecot.fr ">news:4D2CE3=
8B-D169-478B-AEBF-C19F20DCE4CC@labecot.fr...

style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"=20
dir=3Dltr>Hi,
Is there a way to update the same table on a delete trigger =
?



I need to call an UPDATE statement when a delete occurs.



Best regards



style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span>
style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space"> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span>
style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space"> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"LINE-HEIGHT: 13px; FONT-FAMILY: Arial; COLOR: =
rgb(67,117,254); FONT-SIZE: 12px; -webkit-text-decorations-in-effect: =
underline"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span>
style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space"> style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span>
style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space">
-- 
style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; =
BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; =
ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px"=20
class=3DApple-style-span>
Kevin Labecot, Innovantic



T=E9l. : 05.56.45.60.54

class=3DApple-interchange-newline> id=3Dbf46b9df-b332-45ea-bd9d-206b8df6f1be=20
src=3D"cid:8F549F426BC345768F04B18444217C3B@Joo" width=3D189 =
height=3D40=20
apple-height=3D"yes" apple-width=3D"yes">
=20
=
> AN>


------=_NextPart_001_0055_01CB0EDA.F67D3050--

------=_NextPart_000_0054_01CB0EDA.F67D3050--