I would recommend that you give the user a way of specifying a part of the value he's looking for. This could be done using the like operator.
So instead of selecting every unique value, you select every unique value that is like the value given: Select VALUE From MYTABLE Where VALUE Like szUserGiven Group By VALUE Order By Value HTH, Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk -----Original Message----- From: SCISOFT [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 1:51 PM To: 'MapInfo-L (E-mail)' Subject: RE: MI-L ReDim size limit The obvious way is to count them (SQL query), and dimension the required number of arrays of the maximum / optimum size. It doesn't require much more management of your code. Arrays are hungry things. ILT -----Original Message----- From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 April 2004 5:06 PM To: MapInfo-L (E-mail) Subject: MI-L ReDim size limit Listers, Is there anyway around the ReDim size limit of 32767? I'm doing a SQL select to find all the unique values for a given column and then populating an array with all these values, which is then used in a dialog popupmenu control. Problem is that some of our tables could well contain more than 32767 unique values so how do I get around this? Any suggestions gratefully received. Regards Greg Driver Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11485 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11486
