Hi, i'm triying elevatedb and i want to create a sample trigger. I have a Database called
"Tutorial" with two tables "CUSTOMERS" and "DATOS" i try to create this trigger before
insert "CUSTOMERS" by ElevateDB Manager:

BEGIN
 UPDATE DATOS
 SET CONTADOR=CONTADOR+1;
END

CONTADOR is a field of DATOS table that i want to increase when i add a register in the
table "CUSTOMERS" but it gives me the error:

"Invalid expresion DATOS found, the referenced cursor does not exist"

Can you help me?

Thank you

Francisco


Try this

BEGIN
EXECUTE IMMEDIATE ' UPDATE DATOS SET CONTADOR=CONTADOR+1';
END

Roy Lambert [Team Elevate]

Thank you for your fast response.

Where can i find examples of triggers to see sintaxis?

Francisco

Francisco


Look at

Chapter 7
SQL/PSM Statements

in the edb1sql.pdf. That's about as good as you'll get.

Roy Lambert