David, Yes there is a limit to the choose. You either need to limit the choose with a previous WHERE clause or you need to build a form and use one of the objects like a VariableListView.
Jan -----Original Message----- From: "Fitts, David A." <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 7 Nov 2008 15:37:06 -0500 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
