Re: Triggers
Hi Niraj!
Nope. This is not allowed...
Rgds
Karlsson
Sood_Niraj/SO@instru.fi wrote:
> --openmail-part-003c074b-00000002
> Content-Type: text/plain; charset=ISO-8859-1; name="Triggers"
> Content-Transfer-Encoding: quoted-printable
>
> Hi every,
> Is it possible to launch trigger on the table itself. For example I'm
> running the following trigger and I get -747 error. According to
> Informix syntax is Ok!
>
> CREATE TRIGGER up_medtabinsert> INSERT ON measurement
> FOR EACH ROW
> (UPDATE measurement
> SET Phone_Number =3D '999-777770'
> WHERE measurement_event =3D 'CA' AND measurement_id =3D 9999));
>
> Thanks for your help.
>
> niraj sood
> niraj.sood@instru.fi
>
> --openmail-part-003c074b-00000002
> Content-Type: application/rtf; name="Triggers"
> Content-Transfer-Encoding: base64
>
> e1xydGYxXGFuc2lcZGVmZjB7XGZvbnR0Ymx7XGYwXGZyb21hbiBUbXMgUm1uO317XGYxXGZy
> b21hbiBDb3VyaWVyIE5ldzt9fXtcY29sb3J0YmxccmVkMFxncmVlbjBcYmx1ZTA7XHJlZDBc
> Z3JlZW4wXGJsdWUyNTU7XHJlZDBcZ3JlZW4yNTVcYmx1ZTI1NTtccmVkMFxncmVlbjI1NVxi
> bHVlMDtccmVkMjU1XGdyZWVuMFxibHVlMjU1O1xyZWQyNTVcZ3JlZW4wXGJsdWUwO1xyZWQy
> NTVcZ3JlZW4yNTVcYmx1ZTA7XHJlZDI1NVxncmVlbjI1NVxibHVlMjU1O1xyZWQwXGdyZWVu
> MFxibHVlMTI3O1xyZWQwXGdyZWVuMTI3XGJsdWUxMjc7XHJlZDBcZ3JlZW4xMjdcYmx1ZTA7
> XHJlZDEyN1xncmVlbjBcYmx1ZTEyNztccmVkMTI3XGdyZWVuMFxibHVlMDtccmVkMTI3XGdy
> ZWVuMTI3XGJsdWUwO1xyZWQxMjdcZ3JlZW4xMjdcYmx1ZTEyNztccmVkMTkyXGdyZWVuMTky
> XGJsdWUxOTJ9e1xpbmZve1xjcmVhdGltXHlyMTk5N1xtbzlcZHkxNlxocjE4XG1pbjU1XHNl
> YzQ2fXtcdmVyc2lvbjF9e1x2ZXJuMTk3OTg1fX1ccGFwZXJ3MTE5MDhccGFwZXJoMTY4MzNc
> bWFyZ2w3MjBcbWFyZ3IyNTA1XG1hcmd0MTQ0MFxtYXJnYjE0NDBcZGVmdGFiNzIwXHBhcmRc
> cWxcbGkwXGZpMFxyaTI4e1xmMVxmczIwXGNmMFx1cDBcZG4wIEhpIGV2ZXJ5LH17XHBhcn1c
> cGFyZFxxbFxsaTBcZmkwXHJpMjh7XGYxXGZzMjBcY2YwXHVwMFxkbjAgSXMgaXQgcG9zc2li
> bGUgdG8gbGF1bmNoIHRyaWdnZXIgb24gdGhlIHRhYmxlIGl0c2VsZi4gRm9yIGV4YW1wbGUg
> SSdtIH1ccWx7XGYxXGZzMjBcY2YwXHVwMFxkbjAgcnVubmluZyB0aGUgZm9sbG93aW5nIHRy
> aWdnZXIgYW5kIEkgZ2V0IC03NDcgZXJyb3IuIEFjY29yZGluZyB0byB9XHFse1xmMVxmczIw
> XGNmMFx1cDBcZG4wIEluZm9ybWl4IHN5bnRheCBpcyBPayF9e1xwYXJ9XHBhcmRccWxcbGkw
> XGZpMFxyaTI4e1xmMVxmczIwXGNmMFx1cDBcZG4wXHBhcn1ccGFyZFxxbFxsaTBcZmkwXHJp
> Mjh7XGYxXGZzMjBcY2YwXHVwMFxkbjAgQ1JFQVRFIFRSSUdHRVIgdXBfbWVkdGFiaW5zZXJ0
> fXtccGFyfVxwYXJkXHFsXGxpMFxmaTBccmkyOHtcZjFcZnMyMFxjZjBcdXAwXGRuMCBJTlNF
> UlQgT04gbWVhc3VyZW1lbnR9e1xwYXJ9XHBhcmRccWxcbGkwXGZpMFxyaTI4e1xmMVxmczIw
> XGNmMFx1cDBcZG4wIEZPUiBFQUNIIFJPV317XHBhcn1ccGFyZFxxbFxsaTBcZmkwXHJpMjh7
> XGYxXGZzMjBcY2YwXHVwMFxkbjAgKFVQREFURSBtZWFzdXJlbWVudH17XHBhcn1ccGFyZFxx
> bFxsaTBcZmkwXHJpMjh7XGYxXGZzMjBcY2YwXHVwMFxkbjAgU0VUICBQaG9uZV9OdW1iZXIg
> PSAnOTk5LTc3Nzc3MCd9e1xwYXJ9XHBhcmRccWxcbGkwXGZpMFxyaTI4e1xmMVxmczIwXGNm
> MFx1cDBcZG4wIFdIRVJFIG1lYXN1cmVtZW50X2V2ZW50ID0gJ0NBJyBBTkQgbWVhc3VyZW1l
> bnRfaWQgPSA5OTk5KSk7fXtccGFyfVxwYXJkXHFsXGxpMFxmaTBccmkyOHtcZjFcZnMyMFxj
> ZjBcdXAwXGRuMFxwYXJ9XHBhcmRccWxcbGkwXGZpMFxyaTI4e1xmMVxmczIwXGNmMFx1cDBc
> ZG4wXHBhcn1ccGFyZFxxbFxsaTBcZmkwXHJpMjh7XGYxXGZzMjBcY2YwXHVwMFxkbjAgVGhh
> bmtzIGZvciB5b3VyIGhlbHAufXtccGFyfVxwYXJkXHFsXGxpMFxmaTBccmkyOHtcZjFcZnMy
> MFxjZjBcdXAwXGRuMFxwYXJ9XHBhcmRccWxcbGkwXGZpMFxyaTI4e1xmMVxmczIwXGNmMFx1
> cDBcZG4wIG5pcmFqIHNvb2R9e1xwYXJ9XHBhcmRccWxcbGkwXGZpMFxyaTI4e1xmMVxmczIw
> XGNmMFx1cDBcZG4wIG5pcmFqLnNvb2RAaW5zdHJ1LmZpfXtccGFyfVxwYXJkXHFsXGxpMFxm
> aTBccmkyOHtcZjFcZnMyMFxjZjBcdXAwXGRuMFxwYXJ9XHBhcmRccWxcbGkwXGZpMFxyaTI4
> fQ==
>
> --openmail-part-003c074b-00000002--