dear mailing list,
i would like to have a insert-trigger that does something, if the insert statement
left some
attributes on null.
consider having a trigger t_x set up for table x:
// drop table x
//
create table x( a int )
//
// drop trigger t_x of me.x
//
create trigger t_x for me.x after insert execute(
var dummy int;
if NEW.a = null then
set dummy = 1;
)
//
if i want SQLStudio to get these statements executed i get an "-8010: Table name must
be in from list" error. if i replace "NEW" with ":NEW" it becomes an "-7045: Parameter
spec
not allowed"
given to the replication manager, i get the same error message.
do you have an idea what's wrong?
btw: i noticed, that it often does make a difference whether you execute your
statements with the repmcli or SQLStudio. For example, i never managed to write
even the simpliest dbproc with repmcli although it is no problem with SQLStudio...!?
regards,
Patrick Stiegeler
--------------------------------------
Information Technology
Telefon: 0761 / 50318-221
Fax: 0761 / 50318-30
ClinIT AG - Germany
Hornusstr. 16
79108 Freiburg
http://www.ClinIT.net
