Search results

  1. L

    Write trigger with condition

    That was exactly what i needed Thank you very much Norman. Today, I feel so happy. You help me solve my problem. Our soccer team won yesterday in World-cup. After 48 years, we got 1 win in World-cup. Again, I really appreciate for your help.
  2. L

    Write trigger with condition

    Hi all fellows! I have the feeling sorry for all folks because I posted new thread whenever I had some problems. However, I think you may understand me because you underwent this kind of experience. CREATE TABLE test1 (f1 CHAR(100)). CREATE TABLE test2 (f1 CHAR(100), f2 INTEGER, f3...
  3. L

    Data Transformation from 4GL to SQL92

    Hi fellows! I made SQL92 trigger. There's no problem with SQL92 trigger It works very well. However, there is just one problem. We have application using 4GL. This application is connected with another application using SQL92. Actually, the former insert one row into table...
  4. L

    Which patch should I use?

    Hi folks! I am little bit confused about patch My System outline is like : AIX 4.3.3 Progress 9.1B I try to user patch version 9.1C16. I don't know it is okay to use patch 9.1C16. Any help is welcome. P.S> I also need how to patch. Is it okay just to overwrite...
  5. L

    Urgent and Immediate: SQL92 trigger not fired.

    Hi Everyone!! I posted first thread in my life. There's no response. I think that my explanation is so sophiscated so nobody answer me. I again try to explain my situation. My system IBM AIX 4.3.3 Progress 9.1B Patch : 9.1C16 JDK 1.3.1 First table create table test1 (f1...
  6. L

    Trigger not fired

    Hi folks, I made trigger and two table test5, test5_ioilink. Wherenever I try to insert some value on test5, an error occurs. Is there anyone familiar with this kind of error. I need an angel's help. Thanks in advance Changlim Lee insert into test5 values('AAA'); === SQL Exception 1...
  7. L

    The problem with creating trigger with date type

    Hello, I am first steps on Progress db. I try to create trigger. There's no problem with trigger. I think there's something with table which name is 'wo_mstr'. In this table, there is column which name is 'wo_record_date' wo_record_date's value is now sysdate. I try to 'null' value...
Top