Hi All,

I'm having problems writing sql code from a informix odbc source in which i create a temporary table, here is basic sql code which shows what i am trying to do.

SELECT SUM(dqty) qty,SUM(dtpr) price,dcust,delvno,dedate
FROM delvitems,delv
WHERE (dedate >= "01/01/06"
AND dedate <= "31/12/06")
AND delvnoa = delvno
GROUP BY dcust,delvno,dedate
INTO temp aaa;

SELECT *
FROM from aaa

This code is just a test to create a temporary table for more complex reports.
At the moment i'm using winsql to try this example, i have also used crystal reports 10 using the add command method but it still does not work .The odbc is set up correctly as i can run the above statement without the INTO temp aaa; and it works.The more complex reports i have written in informix use many temporary tables which i am trying to convert into crystal reports.
The error message i get is table aaa does not exist.I have used the informix 2.80 odbc driver which was configured with setnet 32 and i can connect.I just can't seem to create a temporary table. I have connected as different users i.e informix as it seems to be a permissions problem. I know the above code is basic and i don't need the into temp command for it to work. it is just an example to create the temporary table.The code works fine from within informix 7.3 which is based on our unix server.

hi,
i have the same problem, so if you have any solution i will be very glad
to recive it.
moti ulus

It is working fine for me:

You must not disconnect your session between select ... into temp aaa; and select ... from aaa; because scope of the temp table is session.
HTH