David, Usually the user knows part of the name (or at least the first letter), so first ask to enter part of the name and then use the choose to select from only those that start with whatever the user entered.
Bernie Lis ----- Original Message ----- From: Fitts, David A. To: RBASE-L Mailing List Sent: Friday, November 07, 2008 3:37 PM Subject: [RBASE-L] - Choose limitations? 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
