What happens if you perform all your queries to a
specifically-named temporary table? E.g. instead of:

select * from MyTable where MyField = SomeValue

you use:

select * from MyTable where MyField = SomeValue into TMP

Then you can access the values in TMP just like any table, and
you are only creating a single extra table? (Which is easy to
drop later since you always know its name.)


Andreas Hartmann wrote:
> 
> Ditto.
> Real pain though to close all those tables :-)
> Put a loop in to save them peridocially - that didn't help either.
> Put a loop in to close temp tables - that didn't help either.
> Tried different ways of searching - that didn't help either.
> Mind you - on a PentiumII400 with 120MB RAM (NT4SP4) the process didn't
> really slow down that much.
> Who knows...
> Andreas
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to