RE: Dinamic statement in trigger

2007-01-15 Thread Anhaus, Thomas
Dusan Kolesar wrote : > > > Dusan Kolesar wrote : > > > >> >> > >> >> Hello, > >> >> is it possible to access trigger variables in dinamic sql > >> statement: > >> >> > >> >> CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE > >> >> ( > >> >>VAR > >> >> EVENTTABLEID FIXED(

Re: Dinamic statement in trigger

2007-01-15 Thread Dusan Kolesar
On Mon, 15 Jan 2007 14:53:14 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : >> >> Hello, >> is it possible to access trigger variables in dinamic sql statement: >> >> CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE >> ( >>VAR >> EVENTTABLEID

RE: Dinamic statement in trigger

2007-01-15 Thread Anhaus, Thomas
Dusan Kolesar wrote : > >> > >> Hello, > >> is it possible to access trigger variables in dinamic sql > statement: > >> > >> CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE > >> ( > >>VAR > >> EVENTTABLEID FIXED(10); > >> COLNAME VARCHAR(30); > >> STMT VARCHAR

Re: Dinamic statement in trigger

2007-01-15 Thread Dusan Kolesar
On Mon, 15 Jan 2007 08:27:22 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote : Hello, is it possible to access trigger variables in dinamic sql statement: CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE ( VAR EVENTTABLEID FIXED(10); COLNAME

RE: Dinamic statement in trigger

2007-01-14 Thread Anhaus, Thomas
Dusan Kolesar wrote : > > Hello, > is it possible to access trigger variables in dinamic sql statement: > > CREATE TRIGGER EMPLOYEE_UPDATE FOR EMPLOYEE AFTER UPDATE EXECUTE > ( >VAR > EVENTTABLEID FIXED(10); > COLNAME VARCHAR(30); > STMT VARCHAR(100); > COLCHNG FIXED(38);