Re: [Pythoncard-users] still lost on typing on comboBox

[Ed L. <ed...@le...>]

On Jan 3, 2005, at 8:46 AM, Brian Debuire wrote:

> - My=A0app=A0manipulates data from a database (MySQL)
> - I need a widget that when I type the primary key or I start typing,=20=

> if there is it on the DB, it autocompletes and / or shows a list of=20
> options on the combobox with the PK that starts with the code I am=20
> typing.

	You would have to query the database for all the possible values=20=

before you could do this. Otherwise, you'll be making a full round-trip=20=

to the database with every keystroke. Then compare the typed text with=20=

the sorted results of your query, and then update the control as=20
needed.

	How many values are you going to be searching on? Needless to =
say,=20
this won't work all that well with a table with several million=20
records.

      ___/
     /
    __/
   /
  ____/
  Ed Leafe
  http://leafe.com/
  http://dabodev.com/