defer interrupt.

I'm currently trying to figure out how to properly use 'defer interrupt' and 'options sql interrupt on' to stop sql queries. I know I have to check on int_flag everywhere but when I try to use it with 'foreach' loops then I don't seem to have much control over when it's detected. Are there any guidelines out there on the best use of this feature or something that helps me better to understand this. (F.ex. should I rather use open,fetch,close than foreach. Shall I use it after every possible SQL-statement or just some.) With thanks in advance, Kristjan Gaukur Kristjansson gaukur@rhi.hi.is