TDBComboBox question

[xaver13]

Hello I have problem to get checked value from TDBComboBox

I fill it

Code: Pascal  [Select][+][-]

1.   DBCmbTyp.Items.Add('n/a');
2.   while not Query11.EOF do
3.   begin
4.     if Query11['col_3'] <> null then
5.       DBCmbTyp.Items.Add(Query11['col_3']);
6.       Query11.Next;
7.   end;

But how to get which value user selected ?

I can compile something as

Code: Pascal  [Select][+][-]

1. DBCmbTyp.Text

I need to use it in a code

Code: Pascal  [Select][+][-]

1. Query1.SQL.Text := 'Select * From wallet where col_3 = ' + DBCmbTyp.Text;
2.  

but it works not.

Please do you know simple and clever solution?

Thank you very much for help.

[PatBayford]

DBCmbTyp.Items holds the text values of the entries.
DBCmbTyp.ItemIndex holds the index of the selected item in the list, assuming you do not allow multi-select.
So, the selected entry from  the list is given by DBCmbTyp.Items[DBCmbTyp.ItemIndex]

[kapibara]

If your intention is to do master/detail (using one query or list to select a resultset with another query) then you may have a look at the tutorial below. There is no need to set the SQL.Text manually, it is automatic if you learn how to do it:

http://wiki.freepascal.org/MasterDetail