TIWTGJQComboBoxEx with data from querytable

[Corwin]

HI

I want to use a TIWTGJQComboBoxEx to create a list to choose an item; I take the list from a TBOraQuery.
I connect everything but the combo I do not have any item.
In TIWTGJQComboBoxEx I insert the name of TBOraQuery in Datalink.DataSource and FiledName in the name of the field to display in the combo.
Something is missing?

Regards

P.S.
(if instead use a TIWCGDropDown, everything works)

[Jorge Sousa]

Hello

You need to match the several ComboEx.Items[i].Value to the DataSet values, are you doing this?

[Corwin]

I did not think it was necessary ... there is an object combo that gets automatically (such as TIWCGDropDown)?

and if I have to enter the values manually of what I need datalink?

otherwise I have to do for the table and enter the individual items? as you insert the key and the description?

[Jorge Sousa]

Hi

Yes, only DropDown has items filled by a dataset, because it has ajax loading controlled by a given number of records. We don't want to take the risk to fill the combos with a lot of records.

[Corwin]

understand...

1) and if I have to enter the values manually of what I need datalink?

2) that is correct?

Code: Select all

  while not dm.TBOraSepe1.EOF  do
   begin  IWCGJQComboBoxExAzie.Items.AddOption(dm.TBOraSepe1.FieldByName('SEDE_DESCR').AsString,dm.TBOraSepe1.FieldByName('EL').AsString, True);
 dm.TBOraSepe1.Next;
  end;


[Jorge Sousa]

Hi again

not quite correct

Value is the key

i would do this,

Code: Select all

var
  Item: TIWCGJQComboBoxExItem;
begin
  dm.TBOraSepe1.First;
  while not dm.TBOraSepe1.EOF do
  begin
    Item:= IWCGJQComboBoxExAzie.Items.Add;
    Item.Value := IntToStr(dm.TBOraSepe1.FieldByName('EL').AsInteger); // ????
    Item.Caption:= dm.TBOraSepe1.FieldByName('SEDE_DESCR').AsString; 
    dm.TBOraSepe1.Next;
  end;
end;


if this is called in an ajax (or async) event, you need to call aditionally

IWCGJQComboBoxExAzie.AjaxReRender

[Corwin]

Hi again, Jorge

actually works, thanks ...

but explain to me what is the datalink because I have to do things manually?

regards
Raul

[Jorge Sousa]

Hello

In this case, the DataLink only selects the Item / Caption, for the currrent value.

[Corwin]

ok ...

last question ..
how to control the selection in the combo box (then I do a query for a combo next connected)? old Delphi had onExit ...

Regards

[Jorge Sousa]

You will find the suitable event in ComboBoxEx.JQComboBoxExOptions

http://www.cgdevtools.com/docs/_html/IWCGJQComboBox.TIWCGJQComboBoxExOptions.htm