In Informix you can "select * from ExistingTable insert into TEMP NewTable".
You can also "create TEMP table NewTable(...)". The table created is only
visible by the process that created it, is "in memory" on the server, and
only lasts as long as the process is connected - you don't need to
explicitly drop it (although you can).
Does Interbase have anything equivalent to this?
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
