1)
X++:
q = new Query();
qbds = q.addDataSource(tableNum(InventTable));
qbds.addRange(fieldNum(InventTable, ItemId)).value('*a,b');
дает запрос
Цитата:
SELECT * FROM InventTable WHERE ((ItemId LIKE N'*a' OR ItemId = N'b'))
2)
X++:
q = new Query();
qbds = q.addDataSource(tableNum(InventTable));
qbds.addRange(fieldNum(InventTable, ItemId)).value(queryValue('*a,b'));
дает запрос
Цитата:
SELECT * FROM InventTable WHERE ((ItemId = N'*a,b')) - поиск точного значения