Jan 9, 2012

Filter through the query


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: