use locate

BIZ TMS Scripter
2

Hello,


such construction will create a variant array in variable "arr". You must use SetOf to convert the variant array to a set type:

 Query1.Locate('cust_code;item_no', SetOf(['A0001','20']),[]); 

For empty sets, just use 0 (zero) instead of [].