Hi,
Try this...
Query query;
QueryRun queryRun;
QueryBuildDataSource qbds;
SalesTable salesTable;
;
query = new Query();
qbds = query.addDataSource(tableNum(SalesTable));
qbds.addRange(fieldNum(SalesTable,SalesId)).value("00403_036..00412_036");
queryRun = new QueryRun(query);
while(queryRun.next())
{
SalesTable = queryRun.get(tableNum(SalesTable));
info(SalesTable.SalesId + ", " + SalesTable.CustAccount);
}
Also, I'll give you a trick; use strFmt function inside addrange().value()
function that will help u a lot...
Good luck!
Regards,
Muthukrishnan
gokhaleanu <[EMAIL PROTECTED]> wrote:
Hi All,
I am using query object in a batch process.
User selects input criteria using above query. (e.g. Item no 0001..0020)
I need to retrieve this whole input string (0001..0020) to process
these records.
I am getting one by one records using
while (queryRun.next())
{
inventTable = queryRun.get(tablenum(InventTable));
print inventTable.ItemId;
}
But I need whole string (0001..0020)
Please give some inputs in this regards.
Thank you,
Anuradha
---------------------------------
Did you know? You can CHAT without downloading messenger. Click here
[Non-text portions of this message have been removed]