> It seems as if I only gets the last value returned to me....

Put the SUSPEND inside the FOR loop.

Warning: this will only re-calc all selectivity if you do a
fetch "all rows".

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com