🚀 go-pugleaf

When using Jdbcombobox and a QueryDataSet you need to define a picklist
for
the component.
What I ended up doing was extending the class and overriding the
bindDataSet() method with the following:

  private void bindDataSet() throws DataSetException {

   Column column;
    if (boundDataSet != null && boundDataSet.isOpen() &&
       (column = boundDataSet.hasColumn(columnName)) != null) {
      PickListDescriptor pickList = column.getPickList();
      if (pickList != null) {
       DataSet pds = pickList.getPickListDataSet();

        String[] dispCols = pickList.getPickListDisplayColumns();
        Object[] items = new String[pds.getRowCount()];
        pds.first();
        while (!pds.atLast()) {
          Variant value = new Variant();
          pds.getVariant(dispCols[0], value);
          items[pds.getRow()] = value;
          pds.next();
        }
        setItems(items);
      } else {
        DataSet ds = boundDataSet;

        Object[] items = new Object[ds.getRowCount()];
        ds.first();
          for(int x=0;x <  ds.getRowCount(); x++) {
         Variant value = new Variant();
         ds.getVariant(columnName,value);
            items[ds.getRow()] = value;
            ds.next();
        }
        setItems(items);
      }
    }
  }

Now it works like expected.

hope this helps,
-stephan

Jeroen Zwartepoorte wrote:

> Thanks for the reply BUT...
>
> I know that already. I want to use it like the dbSwing components are
> meant to be used. That means that i just want to set the dataset &
> columnname property and that i want the dbSwing component to do the
> rest.
>
> Jeroen Zwartepoorte
> Jeroen@xs4all.nl