Re: "tempfile" is too large

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That seems to do the trick.
I replace eval() with &

kind regards
christophe

"Jeroen van Kalken" <I@xxxxxxxxxxxxxx> schreef in bericht
news:3mesp39c9k07cbclumamqpvuoah9mdrj7q@xxxxxxxxxx
On Mon, 28 Jan 2008 20:20:00 +0100, "news.microsoft.com" <no> wrote:

Could very well be since you are joining 2 tables...
If I'm not mistaken the EVAL() will only be done once, therefore
making a complete outerjoin of the two tables.
In this case you should use a macro-expansion

hmmm,

Hardly to imagine one table has 800 records (+-30 fields) the other 300
records (4fields) ....

regards
christophe
"Villi Bernaroli" <a@xxxxxxxxx> schreef in bericht
news:O0U15HcYIHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
Villi Bernaroli wrote:

I got this message when running a report.
File c:\docume~1\christ~2\locals~1\temp\00004nx50025.tmp is too
large. when running :
SELECT * FROM trl,trlservice WHERE EVALUATE(afdrukdepotfilter) INTO
CURSOR "afdruktrl" readwrite

anybody an idea ?

Maybe your cursor went over the 3GB limit in VFP?

Sorry, I meant the 2GB limit.
--
News Microsoft






.

Relevant Pages