In new form->write a method in DS->
void filterOnVendTable()
{
QueryBuildRange vendorAccountFilter;
;
vendorAccountFilter = this.query().dataSourceNo(1).addRange(fieldnum(VendTable, AccountNum));
vendorAccountFilter.value("3000..3010");
}
____
Call this method in DS->Init()
public void init()
{
super();
this.filterOnVendTable();
}
hi
ReplyDeleteI have a Form with Header using Student TABLE with Field as StudentId and Line Using Marks TABLE with Fields as StudendId , Subject , Result(Enum:Pass,Fail).Here my Requirement is when we open a Form it should Show only Subjects whose Result is Pass for Particular Record Selected in Header(Student Table).And when we Click a Button in Line it should show all Subjects i.e Both Pass and Fail, for particular Record Selected in Header .Here i Could Filter By writing QueryRange in Init method of Marks DataSource.But how to get all Subjects for particular Record Selected in Header i.e both passed and failed Subjects.Please help me out
Thank You
Chinna
thank's it's work fine with me
ReplyDelete