Hello..
How to remove the data source added to qbds
[FormDataSourceEventHandler(formDataSourceStr(PurchEditLines, PurchParmLine), FormDataSourceEventType::QueryExecuting)]
public static void InventDim_OnQueryExecuted(FormDataSource sender, FormDataSourceEventArgs e)
{
QueryBuildDataSource qbds,qbdsUser,qbdsLocation,qbdsInventDim;
PA_WarehousesUsers PA_WarehousesUsers;
InventLocation inventlocation;
PurchParmUpdate PurchUpdate;
PurchParmLine PurchParmLine;
FormRun formRun= sender.formRun();
Object salesline_ds = formRun.dataSource(formDataSourceStr(PurchEditLines, PurchParmUpdate)) as FormDataSource;
PurchParmUpdate salesline = salesline_ds.cursor();
str user = curUserId();
select PA_WarehousesUsers where PA_WarehousesUsers.UserId == user;
if(PA_WarehousesUsers && salesline.SpecQty == PurchUpdate::All)
{
qbds = sender.query().dataSourceTable(tableNum(InventDim));
qbdsUser = qbds.addDataSource(tableNum(PA_WarehousesUsers));
qbdsUser.addLink(fieldNum(PA_WarehousesUsers, InventLocationId), fieldNum(InventDim, InventLocationId));
qbdsUser.addRange(fieldnum(PA_WarehousesUsers, UserId)).value(queryValue(user));
}
else
{
sender.query().dataSourceTable(tableNum(InventDim)).clearDynalinks();
FormObjectSet ds = formRun.dataSource(); // caller form's datasource
ds.reread();
ds.research(true);
}
}
I need to clear just the new data source , clear range now appropriate with me in this case .
Thanks all
