Hi Everyone,
I am trying to use the CHOOSE command to select an ID number into a variable from a table of names. The table is a list of 10,000+ names. The table has the ID number as a primary key. I am able to get a list to choose from when the CHOOSE command has a WHERE clause yielding about 300 names but when trying to select from all 10,000+ names I keep getting an insufficient memory error. After the error message clears, I get names from A through D but nothing beyond. Is there a limit to the CHOOSE command or is it time to buy more RAM? (I've got 512mb running XP) Thanks for any advice. David Fitts State of Maine Risk Management
