I call my doctor and left a message telling him I am having a hard time retaining the Rowesa enema, and could he switch me to the foam.(as was suggested by a few people here)
Nope.
He (actually someone from his office) called me back, and told me to take one suppository every day for 2 weeks, and then try the Rowesa enemas again.
I wonder why he is reluctant to give me the foam. Had it been him I talked to I would have asked, but it was second hand.