Monday, September 10, 2007

How to Use '||' (OR) operator in Query

Range range;

QueryBuildRange qbr;

custaccount account = '4008';

name name = 'Velofix AG';

;

super();

qbr = this.query() .datasourcetable (tablenum( custTable) ).addrange( fieldnum( custtable, recid));

// you can use every field here

range = strfmt('((%1 == \"%2\") || (%3 == \"%4\"))',fieldstr( CustTable, Name),name, fieldstr( CustTable, InvoiceAccount) ,account) ;

qbr.value(range) ;


Or add in on field in the range from form((Name == "Velofix AG") || (InvoiceAccount == "4008"))