Triggers

--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_medtabinsertINSERT 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--