DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11
    Join Date
    Aug 2000
    Thanks guys,
    I can't use a trigger because the column is not going to be updated. They are new(blanK) columns that new customer will put in thier activity_id. So it's a one time thing, it's not like it will be updated at a later time. The idea is that incase customers forget to put in thier activity_id, then it should default to 000. So i don't think a trigger will work.
    To answer tamil's question, I have tried to make the column NULL and NOT NULL but none of them seem to work. Also during the insert I don't specify the column. I have also tried specyfying the column as well but still, it's not working out.
    When the front-end that uses power builder tries to insert data into that column, it comes out blank instead of 000

    Any more ideas?

  2. #12
    Join Date
    Oct 2000
    From what charity is describing, I am sure that triggers will not help, but I can't think of any way right now? Sorry.

  3. #13
    Join Date
    May 2000
    Portsmouth, NH, USA


    How is the column inseted into the DB?
    Is it thru a JAVA or XML application? Like thru a web-site?

    - Magnus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.