DBLOOKUPCOMBOBOX - ADDING NEW VALUE!

[selena1]

Does anybody know how to enable that in DBLookupComboBox you can insert new value that don't exists in a list of values wich you get setting properties ListSource and ListField.
I have used DBComboBox component and next code:

while not Query1.Eof do
begin
DBComboBox1.Items.Add(Query1..FieldByName('State').AsString);
Query1.Next;
end;

Is there any better way?

THANKS!

 

[VintageWine]

DBLookupComboBox gets it look list from another dataset so to add another item to the list you must add another record to the lookup dataset.

The method you are suggesting is otherwise the best using out of the box Delphi.

 

[svanels]

The DBLookupComboBox is to ensure data consistency, that means that only valid entries are made. The data entered must be somewhere defined in a look-up table. The only way would be editing the look-up table and refreshing the listsource (query).

Check out: How to use Look Up fields with Tables /Queries faq102-1212 for a more concise explanation.

On the otherhand you should use a dbComboBox if you want the freedom of inserting new values.

Steven van Els
SAvanEls@cq-link.sr