you need a commit immediatly after the CREATE LOBAL TEMPORARY ...

2008/7/11 danyschaer <danyschaer@...>:

> 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
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]