temporary table resource limit

rbuser

Hello:

When using multiple groups, around a million records,
Dephi6, RBuilder Enterprise I get the following error:

'Can not generate report. Temporary Table resource Limit'

Any suggestions??

Regards,

Jon

digitalmetaphors

What database are you using? I'm guessing Paradox. What do your data setup
and the queries look like? This has to be due to the query and not the
report. One possibility is that the DB doesn't have enough space to create
the temp file to run the query. If you have a lot of columns then one
possibility is to break the data up into multiple queries so that you are
able to successfully execute them and then patch it back together. To
completely eliminate the possibility of this being an RB issue try to run
this query and display the results in a grid.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

"Jon" wrote in message news:3d417e10$1@dm500....

This is BDE error $2504. It has nothing to do with ReportBuilder. You're
hitting resource limits in the BDE with your query. You could try
increasing some of the INIT parameters in the BDE Administrator to see if
that helps, but in the end you may need to break up the query to generate
smaller result sets.

I think you'll get better suggestions on resolving this if you post a
message in borland.public.delphi.database.desktop or borland.public.bde.
The .desktop group gets more traffic, but is not as focused as the .bde
group. My suggestion would be to post in the .bde group first and if you
don't get a reply try the .desktop group.

Good luck.

Mike