Hello yazid,
Coba mas, gender-nya jangan pakai double quote ("") tapi single quote
('')
Wednesday, April 20, 2005, 12:40:03 PM, you wrote:
> 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 the Yahoo! Terms of Service.
--
Best regards,
abraar mailto:[EMAIL PROTECTED]
-----------------------------------------------
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/
