Kalau di form builder 6i. di field properties --> maximum length aja di set 65. Pada saat user input pasti akan dibatasi.
On 9/9/05, hs4n <[EMAIL PROTECTED]> wrote: > > 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] > > > > > > -- > -----------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 --------------------~--> 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/
