> I'm running them (pasting exactly, and they prepare ok) in the IBO_SQL
> "Execute Statement in Database" - DSQL dialog, which I have used on
> occasion for what seem to be simple ;) tasks outside of something I
> need in an app. Perhaps I should post this in the IBO group.

Your error is extremely simple - you are trying to use a DSQL component
for selecting a result set, and a DSQL component can only return zero or
one row. Basically, you should use DSQL for things like CREATE, INSERT,
UPDATE etc. whereas you should use a CURSOR component for things that
return result sets like SELECT.

So, use the Cursor tab rather than the DSQL tab and Anns statement will
work.

This helps,
Set