>I running into a foxpro error that tells me that a temp file is too large? I'm taking a cursor(12mb) and a table(5mb) combining them through a SQL select statment into another cursor and when this happens I get the message that "C:\temp\X.tmp is too large"
>any suggestions?
>thanks
The Cartesian product mentioned by Hugo is my first suspect, too. The query probably takes a large time before giving this error.
A Cartesian product - combining all records from table A with all records from table B, instead of only matching records - happens when you forget the condition to join the tables (JOIN or the old-fashioned WHERE).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)