🚀 go-pugleaf

"Ren� Thomsen" wrote:
> 
> I want to use the user to type in a letter and when he has typed the first
> letter, i search in a field.
> When he  types a new letter a new search is done, removing all other
> entitites.
> Have tried to set the components dataset to null to remove items, nowork,
> aswell as refreshing the query (with new sql) bound to the component, dosent
> work either.
>  i could use a regular combobox and fill it with strings, however this takes
> forever(strange).

For this purpose, I'd say that a JdbNavComboBox isn't what you want.
There are several ways I'd approach this.  My first approach would be 
to extract the values of that one column into either an array 
or Vector.  Then, when a user types a character, iterate through 
that collection, asking whether each String in it
"startsWith(character)".  
If so, add it to a vector which will be assigned as the model of an 
ordinary JComboBox after the iteration: DefaultComboBoxModel has 
constructors for both array and Vector, if I remember correctly.
By building the model and then assigning it, updating the combobox
list goes faster.

I don't know how fast this will be, but if the number of rows
in the dataset isn't to big, it might be sufficiently fast as
to not annoy your users.

You might look at using some kind of combination of DataSetViews and
dataset filtering -- but I haven't used this often enough to say 
whether it would work.  


Paul Furbacher (TeamB)