>Denise,
>
>At my old job I had to locate the source of some memory problems that started occuring all of a sudden. The cause of the problem was that the source of list boxes were arrays created with select * from .... into array..... As the customer files got bigger the error started cropping up.
>
>I would check for anything similar using the tables in your system that are growing.
>
Thanks, Perry. That's exactly what's happening. One of the tables has gotten rather large and it's causing problems, but they're cropping up in the wierdest places too.
One thing I did find out while going through the code is that whoever orignally wrote it put the select statements to make five arrays in one procedure. So whenever a list was needed the procedure was called. And even if only one list were needed, all five would be made. I corrected that and it took care of the major problems. Now I have to go back and look for the nitpicky stuff.
The problem is that this is in production. So I have to be very, very careful what I do and test every part of the thing whenever I change one little thing. I mean, I don't work in the production environment, of course, but I have to be doublesure of what effects my changes have.
Anyway, guys, thanks very much for the help!!
~~~~~~~~~~
Denise
~~~~~~~~~~