Re: [Firebird-devel] Changing maximum items IN clause

[Andrey P. <pa...@vd...>]

""Claudio Valderrama C."" <cv...@us...> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:NGB...@us......
> Temporary tables shouldn't be an excuse for bad design or lack of
> forethought when creating applications. Have the table created.
You are right but after clearing this table you'll get a garbage collection.
It can be a long process.

> Or does your application scan a full table to concatenate items to produce
> an IN clause?
Yes, I need to delete a lot of records from table which were in dbf file. I
found only two variants, firstly, to scan dbf file and to delete row by row
from IB's table, and, secondly, to import dbf file to IB and then to work
with it as conventional table. The second method was faster.
I want to note it wasn't a regular task.

--
With regards
Andrey Prokhorov