strSQL = "SELECT ISNULL(S1.FVALUE,0) + 1 AS FVALUE\r\n" +
"FROM T_BC_PUBLICSERIALSET S1 WITH(UPDLOCK)\r\n" +
"WHERE S1.FJUSTVALUE = '" + JustValue + "'\r\n" +
" AND FTYPE = '" + TypeValue + "'\r\n" ;
if (!IsPublic)
{
strSQL = strSQL +
" AND S1.FORGID = " + OrganizeID;
}
docValue = DBUtils.ExecuteDynamicObject(ctx,strSQL);
执行到DBUtils.ExecuteDynamicObject(ctx,strSQL)时报以下错误:
parse error. detail message is :
Not support locking hints.
source sql is :
SELECT ISNULL(S1.FVALUE,0) + 1 AS FVALUE
FROM T_BC_PUBLICSERIALSET S1 WITH(UPDLOCK)
WHERE S1.FJUSTVALUE = 'PPBOM00034998'
AND FTYPE = 'PACKBOXBATCHNO'
AND S1.FORGID = 100001
推荐阅读