At 02:57 PM 08-03-02 -0500, you wrote:

>hello...
>
>I've made some progress in my problem... I have deleted almost all of the
>18000 records of teh table "RawData", and have left the table "Spot" as usual
>(with 9000 records more or less). Now my query returns only 8 records, and
>everything has worked fine. It seems that there is an internal limitation of
>the size of these temporary files. Please could anyone tell me how I can
>override this limitation?

See my previous email re allocating more temp file space. The forthcoming
Firebird full release 1 also has solved the absolute limit of 2 Gb for a
single sort file.

As to beating some perceived limitation, 18000 records is a heck of lot to
output in a query. Try to reduce them with some WHERE criteria.

H.

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________