Nick;

Adding a COMMIT does the trick, thank you.
But now, I can't see clearly what means "temporary table" for Firebird.

How do I create temporary tables only available for the session that
created it?. I don't want it available for other sessions; also other
sessions may need to create the same temporary tables at the same time.

Do I need to do an explicit drop to remove the temporary table?

Dany