hi all,
Dialog --
table - Cust Confirm Jour
my query --
public void executeQuery()
{
Query query;
QueryRun qrRun;
QueryBuildDatasource qbds;
QueryBuildRange qbr;
RecId chkRecid;
query = queryRun.query();
qbds = query.addDataSource(tablenum(CustConfirmJour));
// date range
qbr = qbds.addRange(fieldNum(CustConfirmJour,ConfirmDate));
qbr.value(queryRange(fromDate, toDate));
queryRun = new QueryRun(query);
while (queryRun.next())
{
custConfirmJour = queryRun.get(TableNum(CustConfirmJour));
chkRecid = custConfirmJour.RecId;
info(strFmt("%1",chkRecid));
}
i wants to return the latest confirmation doc num. means in the excel screen shot the BOLD marked recid should only return
Kindly let me know what line of code is required to add?
please give me more shed on this.
thanks!
}
