I take your point and it's something I'd realised after my original post, to limit the selection or at least get the user to enter part of the value so as to restrict the search (as Peter Horsbøll Møller commented). The reason I'd gone down my original route was that I thought it would be easier for our users if they where presented with a list of unique values for a chosen table/column, rather than them having to have the correct spelling etc.
Just messing about really, I'll probably be the only one who'll end up using the tool, if I get round to finishing it (nearly there). Thanks for everyone's time though, I appreciate it. Greg > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 16:52 > To: Driver, Greg 9434 > Cc: [EMAIL PROTECTED] > Subject: RE: MI-L ReDim size limit > > From a user interface design perspective, you don't want to have 32k > items in a pick list. My personal threshold is more like 200+/-. You > will want to devise some other way to allow the user to specify the item > in a more complicated way. > > Just my 2c, of course. > > > > -----Original Message----- > From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 2:06 AM > 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. > > > > 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.