Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: create trigger????

    Hi,
    I've two tables: BL (bl_id), FL (bl_id)
    in BL there is the col COUNT_FL. One Building (bl_id) has more FL (floor fl_id). Now the col COUNT_FL is set default to zero.
    When Can I update the col COUNT_FL to see the number of floor on any building???

    Thanks
    Raf

  2. #2
    Join Date
    Sep 2002
    Location
    Quebec
    Posts
    5
    this needs to be an after statement trigger
    (making it a row trigger will result in a mutating trigger)

    be warned tough this will
    result in updating and locking your BL table entirely

    a workaround would be to use
    triggers & package to "push" only updates,inserts or deletes
    in the package variables the update accordingly
    this is a bit longer tough if you want the base scripts for that e-mail me
    i'll send them

Posting Permissions

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