hy guys..
need help or suggestion, syntax dibwh ditulis pd trigger di sybase sql
anywhere, yg jadi masalah waktu execute eror, dia bilang colom
"gender" tidak ditemukan. Padahal gender adalah nilai yg ingin saya
masukkan.
ada pencerahan ???
================
alter trigger "dba".tr_employee_update after update order 2
on "DBA".employee
referencing old as old_employee new as new_employee
for each row
begin
set sSQL='insert into employee_hist(emp_no,emp_col_nm)
values(old_employee.emp_no,"gender")';
execute immediate sSQL
end
====================
thanks
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
