Thursday, 12 November 2015

filtering the data(record) based on selected Input

For filtering a particular record    :

1.First create a table  i.e tabcust  with fields name , ids(baseenum) ,  phno , height , weight
2.create a form and drag the table tabcust into data source.
in design take a grid and a combo box   give enum type as baseenum1;
  1. In class:
public class FormRun extends ObjectRun
{
QueryBuildRange qbr2;  //  declartion of range variable
}

  1. In Data source level . Override a method init()
    public void init()
    {
    super();
    qbr2 = this.query().dataSourceName(“tabcust”).addRange(fieldNum(Tabcust , BaseEnum1));
    }
5.in combo box – in methods override a selectionchange method()
public int selectionChange()
{
int ret;
ret = super();
Tabcust_ds.executeQuery();
return ret;
}

  1. Create a range by  overriding method executequery() in data source level: 
public void executeQuery()
{
qbr2.value(combobox.valueStr());
super();
}

Filter record

No comments:

Post a Comment