hi, cara ini kan tetap saja menerima input > 65 cuma nanti waktu di insert/update ke dbasenya dia akan mensubstring 65 karakter saja. ini kan bisa masalah buat usernya? entah apakah usernya input pake gui atau sql biasa.
kenapa gak di alter table saja? btw, saya pengen nanya, apakah di trigger bisa throw exception ya? kalo bisa apakah berarti semua operasi di rollback? thx --- In [email protected], Edy Sumaryoto <[EMAIL PROTECTED]> wrote: > Mungkin bisa diakalin di pasang di trigger table before insert/update > Ini contohnya nama table MYTABLE dan nama column KOLUM. > semoga membantu > salam, > edys-- > ------------------- contoh script--------------------- > > CREATE OR REPLACE TRIGGER "TR_BI_MYTABLE" BEFORE INSERT ON MYTABLE > > REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW > BEGIN > -- SEBELUM INSERT DIBATASI MAX 65 > :NEW.KOLUM := SUBSTR(:NEW.KOLUM,1,65) > END; > > CREATE OR REPLACE TRIGGER "TR_BU_MYTABLE" BEFORE UPDATE ON MYTABLE > > REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW > BEGIN > -- SEBELUM UPDATE DIBATASI MAX 65 > :NEW.KOLUM := SUBSTR(:NEW.KOLUM,1,65) > END; > -------------------------------------------------------------------------- > On 9/7/05, Kiki Kuswara <[EMAIL PROTECTED]> wrote: > > > > Balik tanya nih, > > > > Kasusnya di form atau secara dml (sql Plus)? > > > > Salam, > > > > Kiki Kuswara > > > > > Dear all, > > > > > > Langsung aja saya punya problem dimana saya punya table salah satu > > > kolomnya sudah di set max lenght 225 char. tapi Sekarang ini saya mau > > agar > > > isi kolom tersebut max 60 char. Kira-kira ada yang tau ga gimana caranya > > > saat user isi kolom tersebut lebih dari 60 maka user tidak bisa ketik > > > lagi > > > > > > Thanks banget ya buat bantuan teman2 semua > > > > > > Salam, > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > -- > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > Keluar: [EMAIL PROTECTED] > > > Website: http://indo-oracle.lizt.org (NEW) > > > ----------------------------------------------- > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > http://indo-thin.vze.com > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
