David,
Further to Razzak's and other suggestions, if you wish to choose from a list which changes as the user types in characters into a Variable Edit field, you can use the On Key Press EEP to create a dynamically changing view, which can then appear in a DBGrid, allowing the user to select the name required. John Engwer provided a sample of this via the list a while ago - it is a very useful approach and provides immediate 'feedback' as the choices available are 'refined' as the user types in characters. If this is what you are after I would suggest that you also look at this approach - let me know if you need any more information. Regards, John Docherty From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fitts, David A. Sent: Saturday, 8 November 2008 9:37 a.m. To: RBASE-L Mailing List 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
