hi ..
Try this..
static void QueryExpressions(Args _args)
{
Query Query;
QueryRun QueryRun;
QueryBuildDataSource QBDS;
InventTable InventTable;
;
Query = new Query();
query.adddatasource(tablenum(InventTable));
query.adddatasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
itemname)).*value(strfmt("Item Name %1 && Item Name %2", "*20*","*pipe"));*
QueryRun = new queryrun(query);
while(queryrun.next())
{
inventtable = Queryrun.get(tablenum(Inventtable));
info(inventtable.itemid);
}
}
On Tue, Sep 22, 2009 at 11:25 AM, Nagesh <nageshsi...@yahoo.com> wrote:
>
>
> Hello everybody,
>
> I am running the following job and getting the error saying 'Query extended
> range failure. right parentheses expected near pos 18.
>
> static void QueryExpressions(Args _args)
> {
>
> Query Query;
> QueryRun QueryRun;
> QueryBuildDataSource QBDS;
> InventTable InventTable;
> ;
>
> Query = new Query();
> query.addatasource(tablenum(InventTable));
> query.datasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
> itemname)).value(strfmt('((Itemname "%1") && ItemName "%2"))', '*20*',
> '*pipe*'));
>
> QueryRun = new queryrun(query);
>
> while(queryrun.next())
> {
> inventtable = Queryrun.get(tablenum(Inventtable));
> info(inventtable.itemid);
>
> }
> }
>
> I am not getting what is wrong with it. Its very urgent.
>
> Thanks in advance
>
>
>
