Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1

Thread: trigger problem

  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,994
    Thanks
    120
    Thanked 76 Times in 76 Posts

    trigger problem

    before update trigger:

    Code:
    set new.id_tezaver = (select IFNULL(id_tezaver,0) from tezaver t where term = new.term and l2='la' )
    --> column id_tezaver can not be null

    Yeah, I know it returns null, but should be sorted by ifnull ?

    EDIT: I see it now, it actualy returns nothing, not null.
    How to write trigger for that ?
    Last edited by BubikolRamios; 02-28-2013 at 09:49 AM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


 

Posting Permissions

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