> I can't believe IB places restrictions on creating temporary tables.

I use two ways round this - because it makes for much better client/server operation.

I use a local memTable component to cache locally required information and so do not load the
server. This works as a TDatabase query and is fine for one of reports.

As structural changes and the likes can cause other problems, I do not plan to do them while
a database is live. So if I need to share data with other users, I use a static temporary
table as others have suggested, but in most cases, a TIBOQuery can be created to provide the
information - live - so no need to copy it at all. That is why temporary tables are not
concidered necessary.

I belive that Jason may be working on an alternative to memTable which will work IBO native,
but don't quote me on that.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services