Thanks Hans
But 1. I thought a temporary table would be more reliable and
And 2. I have not seen anything about 'Memory Tables' in Interbase
orIBO.
Dave.

--- In IBObjects@y..., hans@h... wrote:
> Howabout using a memory table instead?
>
> Best Regards
> Hans
>
> ===================================================================
>
> Dave Bullar wrote:
> >
> > Hi everyone.
> > I want some temporary tables, which need to start empty,
> > but are used quite frequently.
> > >From the point-of-view of Interbase and filling up the database
is it better to:
> > A. empty the table (sql = 'delete from temptable') or
> > B drop the table and then re-create it .
> > sql = 'drop table temptable'
> > sql = 'create table temptable( .......'
> >
> > Your Expert advice Please !!
> > Dave
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/