代码中执行Like查询

执行like查询
如果物料代码的编码形于XXXXXX, 要查询574*的物料代码,可在代码中使用如下方法:
 
string pattern = "574___"; //因为物料编码为6位,所以添加三个下划线填充空位
if( (dstat = oiSqlCreateSelect( &sql )) ||
        (dstat = oiSqlWhereBegParen(sql))||
        (dstat = oiSqlWhereLike(sql, PartNumberAttr, pattern)) ||
        (dstat = oiSqlWhereEndParen(sql)))
        goto EXIT;
if(oiSqlAscOrder(sql, bbkSeqAttr)) goto EXIT;
 
dstat = QueryDbObject(objClass(thisObj), sql, MaxSize, TRUE, SC_SCOPE_WHERE_NECESSARY,
            &objSet, mfail);
 
int size = low_set_size(objSet);
...
原文地址:https://www.cnblogs.com/hcfalan/p/470659.html