unbound list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an unbound list box that the result of a query populates. Are list
boxes bound by a certain number. My database has 300K rows but the most I can
get teh list box counter to idsply is 65K

This is frustrating. I tried to do a select * from my database in this field
and canot get past this value. Is this a microsoft bug?
 
It's not a bug: it's the way they're designed. 65K represents the total
number that can be represented by an integer (-32,768 to 32,767, or 65,535
values), and they're designed to have an internal integer tag associated
with each entry.

My suggestion would be to rethink your design: in my opinion, even 65K is
far too many entries to expect a user to scroll through.
 
So the 65k is just the returned data set from the search. I was attempting to
see if I did a select * if I could return the records. My total design has a
for with a text box that is evaluated as part of the sql statement in a where
clause that will prompt for user name and sort by that wheree it is equal to
the text box value.

That being said, will my query still search all 388K records and list only
those that apply? There will never be 64K in the returned search (that was
for testing), but my concern is that it only searches and returns the first
64K records it finds.

thank you for your help.
 
Back
Top