Juan: We can keep playing 20 questions here, or you can post the actual code. I am not going to keep trying to guess what is happening without seeing what's going on. Nothing that you've described so far should cause an out of memory condition, but there are numerous spots in what you've described that could if coded incorrectly.
On 11/23/06, Juan Carlos García <[EMAIL PROTECTED]> wrote:
At 11:23 21/11/2006, you wrote: Hi Jeffrey. >I'm very curious as to how this line evaluates. It suggests that >perhaps the query is being re-prepared with different criteria each >time through? Yes, it's true. My main form has some fields to select the criteria to extract the information. > Would it be possible to describe what's going on there >as I am thinking that (maybe) the same thing could be accomplished >through the use of placeholders. The target is to obtain a XLS file with the query's records and then, send it to a email direcction. >Also, how are you processing the results? Are you shoving the whole >thing into one big array or are you processing each row and then >reusing the variables? I'm processing each row independently. > Depending on the number of rows being >returned, shoving them all into an array can very quickly chew up all >of your available mmory. The number of records can range between 1 to 18000, more or less. Thanks again for your patience.
-- -------------------------------------------------------------------------------------------------------------- The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis. Dante Alighieri (1265 - 1321) They who would give up an essential liberty for temporary security, deserve neither liberty or security. Benjamin Franklin Our lives begin to end the day we become silent about things that matter. Martin Luther King The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment IV to the Constitution of the United States --------------------------------------------------------------------------------------------------------------
