His drinking problem

Hi!

I saw this movie quite a while ago when it came out and remember that the Gabriel Byrne character had a really bad drinking problem and was given pills that essentially cured him of wanting to drink. Is this the movie where that happened? Does anyone remember what pills he was given?