Announcement

Collapse
No announcement yet.

SQL-preparation; create global temporary table

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!
Working...
X