Temp tables in sql designer

[trier]

Whenever I create a temporary table in the Crystal SQL designer I cannot select from it until the temp table is created eg
SELECT
table1.field1
table1.field2
FROM
table1
INTO TEMP tmpA;
SELECT
tmpA.field1
FROM tmpA
The first time I run this query I get an error message saying that table tmpA does not exist in database.
However if I comment out the second select, then run the first part of the query it seems to create the table, I can then comment out the first select and run the second select and it works fine. Obviously this is not an ideal solution.
We are running a Baan ERP system on an Informix database. We have no problems creating temp tables at Informix level.
Any help would be much appreciated.
Thanks

 

[AWithers]

Would it help if you

first create the table
then insert data into it,
then select everything from it
then drop it

Dont know whether you can do that from CR with Informix

Andy