Trigger ini tidak tercreate di database,
apa ada yg salah?
==========================
string ls_sql
ls_sql = "create trigger 'dba'.tr_aoi_delete after delete order 2
~n~r" + &
"on 'DBA'.area_of_interest ~n~r" + &
"referencing old as old_aoi ~n~r" + &
"for each row ~n~r" + &
"begin ~n~r" + &
" declare m_id double; ~n~r" + &
" declare m_opid char(10); ~n~r" + &
" declare m_cnt double; ~n~r" + &
" // ~n~r" + &
" begin ~n~r" + &
" declare cr_appuser dynamic scroll cursor for
select
app_use_name from appuser where app_use_active='Y'; ~n~r" + &
" open cr_appuser; ~n~r" + &
" fetch next cr_appuser into m_opid; ~n~r" + &
" close cr_appuser ~n~r" + &
" end; ~n~r" + &
" // ~n~r" + &
" set m_id=0; ~n~r" + &
" select 'count'(uac_id) into m_cnt from user_activity;
~n~r" + &
" if m_cnt>0 then ~n~r" + &
" begin ~n~r" + &
" declare cr_id dynamic scroll cursor for select
uac_id from
user_activity order by uac_id desc; ~n~r" + &
" open cr_id; ~n~r" + &
" fetch next cr_id into m_id; ~n~r" + &
" close cr_id ~n~r" + &
" end; ~n~r" + &
" set m_id=m_id+1 ~n~r" + &
" else ~n~r" + &
" set m_id=1 ~n~r" + &
" end if ~n~r" + &
" ; ~n~r" + &
" // ~n~r" + &
" insert into
user_activity(uac_id,uac_user,uac_date,uac_type,
uac_description) values( ~n~r" + &
" m_id,m_opid,now(*),'DL','Delete location
'+old_aoi.aoi_desc)
~n~r" + &
" end "
execute immediate :ls_sql;
=================
--- In [email protected], "Wihartoyo" <[EMAIL PROTECTED]> wrote:
>
> Bisa dan sangat bisa dan akan lebih efektif jika menggunakan dynamic
sql
> format (lihat di help)
> Cuma kalo menggunakan ini sepertinya tidak terasa kalo kita lagi
make PB
> karena semua statemen harus dideklarasikan sebagai string variable.
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of
> yazid
> Sent: Monday, May 22, 2006 2:07 PM
> To: [email protected]
> Subject: [indopb] Create Database Trigger from script PB
>
> PB 6.5 & Database SQL Anywhere
>
> Biasanya saya buat trigger database sql anywhere dari sybase
central.
> Bisa gak buat trigger, yg script triggernya ditulis di script PB ?
> Spt execute immediate "..."
>
> Thanks
>
>
>
>
>
>
> -----------------------------------------------
> IndoPB - Indonesia PB User Group
> Learn PB6 by download FasTrack to PB6 at :
> http://groups.yahoo.com/group/indopb/files/Belajarpb6/
> To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
>
>
>
>
>
> __________________________________________________
> Apakah Anda Yahoo!?
> Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik
terhadap spam
> http://id.mail.yahoo.com
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Everything you need is one click away. Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/NhFolB/TM
--------------------------------------------------------------------~->
-----------------------------------------------
IndoPB - Indonesia PB User Group
Learn PB6 by download FasTrack to PB6 at :
http://groups.yahoo.com/group/indopb/files/Belajarpb6/
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/
