Query Clear ranges and QBRS

HI,

Here we need to build the query and need pass the new value by clearing the old filtered data based on query ranges.

month = MonthYear_args.selection();

qbds = MZK_PayrollProcessed_ds.query().dataSourceTable(tablenum(MZK_PayrollProcessed));

qbds.clearRanges();

or qbds.clearRange(fieldNum(MZK_PayrollProcessed,MZK_MonthYear)); //alternative way of clearing ranges

queryBuildRange = qbds.addRange(fieldnum(MZK_PayrollProcessed, MZK_MonthYear));

queryBuildRange. Value(int2str(any2int(month)));

MZK_PayrollProcessed_ds.executeQuery();

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s