SQL-preparation; create global temporary table

Hi all,

I have a select Statemant, which is is on the limit of relations (255) in Firebird. I think I can solve it with global temporary tables (GTT). Also, I wrote a Statemant which writes my select into a GTT, after that I can use the GTT. My statemant works fine, but when I import it into Scriptcase SQL, it does not work… I tried the creation of the GTT into the SQL-Preparation and in the main SQL, but it does not work, always an error.

Does someone has an idea?

Thank you!