Thanks for your help Ivan - that makes perfect sense.

Ivan Prenosil wrote:

>
>It would also make no sense to break the sequence of statments
>and jump to WHEN at the end of the block after each select.
>FOR SELECT in pseudo code looks like this
> EXECUTE SELECT
> WHILE (100 <> FETCH()) DO ...;
>i.e. each select is eventually ended by SQLCODE 100.
>
>Even if the select does not return any rows, it is not considered error.
>Or do you think that this Pascal command should raise exception ? :-)
> FOR I:=2 TO 1 DO ...
>
>Ivan
>http://www.volny.cz/iprenosil/interbase
>
>
>
>