Would like to have a discreet affair - opportunity has nevery bloody arisen though!
The trouble is that both parties need to be discreet for it to stay discreet and you only have control over your own actions. While the other party may initially also desire it to be discreet, there's no guarantee of how it will end. And it will end, one way or another!
My wife has a few female friends who are divorced. I'm quite sure it's all in my over active imagination, but from things she says they are seemingly always on the hunt for a new squeeze, whether married or not. It could be easy to get into a situation with them - I have been round to fix their computers, garage doors, leaking taps - but I don't see a happy ending. Well OK, I see a short term happy ending, but not a long term one.