Share
Report
54Hi,
i have written display method and captured data on invent table (recent purchased date i.e physical date in invent trans). i am written some code for filter the date range. its not working.
please help me.
void context()
{
int selectedMenu;
real test;
formrun fr;
Args ag;
str strtext;
TransDate dateRange;
querybuilddataSource qb1, qb2;
queryrun qr;
query q = new Query();
PopupMenu menu = new PopupMenu(element.hWnd());
int a = menu.insertItem('Find');
int b = menu.insertItem('Filter');
int c = menu.insertItem('Remove Filter');
selectedMenu = menu.draw();
switch (selectedMenu)
{
case -1:
break;
case a:
ag = new args('SysformSearch');
fr = new formrun(ag);
fr.run();
fr.wait();
strtext = fr.design().controlName("FindEdit").valueStr();
info(strFmt("%1",strtext ));
dateRange = str2Date(strtext, 213);
if(strtext)
q = inventTable_ds.query();
qb1 = q.dataSourceTable(tablenum(InventTable));
qb2 = qb1.addDataSource(TableNum(InventTrans));
qb2.addLink(FieldNum(InventTable,ItemId),FieldNum(InventTrans,ItemId));
qb2.addRange(FieldNum(InventTrans,Datephysical)).value(queryrange(dateRange, dateRange));
inventTable_ds.query(Q);
inventTable_ds.executeQuery();
break;
case b:
q.dataSourceTable(tableNum(InventTrans)).addRange(FieldNum(InventTrans,DatePhysical)).value(queryrange(dateRange, today()));
inventtable_ds.executeQuery();
break;
case c :
inventtable_ds.query().dataSourceTable(Tablenum(InventTrans)).clearRanges();
inventtable_ds.executeQuery();
break;
Default:
break;
}
}
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
