Docs says "the table should be created as a local temporary table that is only visible to the current session."

Running this in EDBMgr

CREATE TEMPORARY TABLE TopTen AS
SELECT CLIENTE, COUNT(*) AS SUMA
FROM MAEXPEDI
GROUP BY CLIENTE
HAVING SUMA > 10
WITH DATA

TopTen table is missing or I can't see it in EDBmgr

Running it again and "TopTen table already exists"

May be I need to change my glasses

Tiago,

I have  the same problem in edbmgr but in application works fine but don't drop table
because you may have problems, wait the next fix.

Sorry, i correct. The problem comes when you try to drop temporary table and it
not exists.

Tiago,

I'm not absolutly sure about this (Tim will correct me if I' wrong ,
but it seems to me that temporary tables are not, as the name indicates,
"persistent" database objects and so, not stored in the database
catalogue, and that's why they don't show in EDB Manager.

--
Fernando Dias
[Team Elevate]

Tiago,

<< TopTen table is missing or I can't see it in EDBmgr >>

EDB Manager does not show temporary tables in the list of normal tables.
They are just "there".  2.03 is going to finally have a catalog table for
temporary tables, and then I can see about adding them as a separate list in
the EDB Manager.

--
Tim Young
Elevate Software
www.elevatesoft.com