thanks untuk masukkannya saya inginnya saat mau entry di kolom tersebut setelah 60 maka tidak bisa diketik apapun tp saya coba trigger tersebut ma tp gpp deh saya batasi aja saat kolom tersebut di ketik lebih dari 60 maka tidak bisa di simpan,
Sekali lagi thanks banget tuk masukkannya Salam, Devi ----- Original Message ----- From: "Edy Sumaryoto" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, September 07, 2005 12:33 PM Subject: Re: [indo-oracle] maximum lenght > 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] > > > > > > > -- > -----------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 > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
