Post reply

how to send trigger messages to Front end

  • July 25, 2008 at 6:48 am

    #196029

    how to send trigger messages to Front end

    i want to trigger on update of record in table

  • July 25, 2008 at 9:51 am

    #848520

    Probably the better way to do this is to have the update proc called by the front end do the messaging. If you absolutely have to have it in a trigger, you can use select or raiserror in a trigger.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 29, 2008 at 4:13 am

    #849655

    I dont think there is any way to return message from the trigger.

    Can do this from the sp using raiserror.

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply