static void Medical_Info(Args _args)
{
Query q;
QueryRun qr;
QueryBuildDatasource qbd;
QueryBuildRange qbr;
Medicine m;
;
q = new Query();
qbd = q.addDataSource(tablenum(Medicine));
qbr = qbd.addRange(fieldNum(medicine,Item_Expired));
qbr.value(queryValue(Item_Expired::No));
qr = new SysQueryRun(q);
while(qr.next())
{
m = qr.get(tableNum(Medicine));
info(m.Item_id);
}
}
No comments:
Post a Comment