Subject | Re: create temporary table |
---|---|
Author | danyschaer |
Post date | 2008-07-11T14:02:07Z |
Hi Milan;
Well, I tried before asking but ...
- The CREATE GLOBAL TEMPORARY "Tbl_B" ... runs successfully.
- If I try select * from "Tbl_B", it says "Tbl_B" does not exists.
- If I try to do INSERT INTO "Tbl_B" SELECT * FROM "Tbl_A", it
says "Tbl_B" does not exists.
- If I try to create again, it says "Tbl_B" already exists.
- If I try to drop "Tbl_B" it does it; then I can create "Tbl_B" again,
but same results.
I checked very well if I am naming correctly, always using exact name
and between double cuotes.
What is wrong?
Dany
Well, I tried before asking but ...
- The CREATE GLOBAL TEMPORARY "Tbl_B" ... runs successfully.
- If I try select * from "Tbl_B", it says "Tbl_B" does not exists.
- If I try to do INSERT INTO "Tbl_B" SELECT * FROM "Tbl_A", it
says "Tbl_B" does not exists.
- If I try to create again, it says "Tbl_B" already exists.
- If I try to drop "Tbl_B" it does it; then I can create "Tbl_B" again,
but same results.
I checked very well if I am naming correctly, always using exact name
and between double cuotes.
What is wrong?
Dany