Hello everyone,
I have created a Form A, in which I have some filters that are activated when ButtonA is clicked.
In class declaration i have:
QueryBuildDataSource qbds1, qbds2;
QueryBuildRange qbr1, qbr2;
In Form's DatasourceA init method:
qbds1 = this.query().dataSourceTable(tableNum(TableA));
qbds1.clearDynalinks();
range1 = qbds1 .addRange(fieldNum(TableA, FieldRange));
qbds2 = qbds1.addDataSource(tableNum(TableB));
qbds2.addLink(fieldNum(TableB, FieldName), fieldNum(TableA, FieldName));
range2 = qbds2.addRange(fieldNum(TableB, FieldRange));
In form's Datasource A, executeQuery method:
range1.value(Control1.valueStr());
range2.value(TableB_Control2.valueStr());
In clicked method of Button A I have:
TableA_ds.executeQuery();
The problem is that when i firstly open the form range2 is applied. How can i remove it ? I want ranges to be applied only when ButtonA is clicked.
I have tried the followed in init method of DatasourceA:
qbds1 = this.query().dataSourceTable(tableNum(TableA));
qbds1.clearDynalinks();
range1 = qbds1 .addRange(fieldNum(TableA, FieldRange));
qbds2 = qbds1.addDataSource(tableNum(TableB));
qbds2.addLink(fieldNum(TableB, FieldName), fieldNum(Table1, FieldName));
qbds2.clearRange(fieldnum(TableB, FieldRange));
range2 = qbds2.addRange(fieldNum(TableB, FieldRange));
Can anyone help please?