> Hi
>
> what re-factoring means?
>
> Thanks
>
> Agostinho
>
> cpis@...
>

Just another suggestion... have a look at the
FOR SELECT ... INTO :VAR DO BEGIN
END
syntax.. you can make your code a lot more reliable, readable and much
faster.
instead of getting count(*) then using a while loop

Alan