Store it in cursor instead of array. Which aggregare function? When you meant something like summary/average/maximum, cursor is much better here than array because you can use SQL SELECT statement to quickly calculate what you need.
> I would like to import a huge table for aggregate function (about 17,000 records). For better performance, i try to store it into array. I get an error "too many variable". Any ideas to solve it?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.