modifying a column - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: modifying a column

  1. #11
    Join Date
    Aug 2000
    Location
    NY
    Posts
    37
    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
    Posts
    22
    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
    Location
    Portsmouth, NH, USA
    Posts
    378

    Question


    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