esql 语句update的where条件里能不能嵌套select????
esql 语句update的where条件里能不能嵌套select ?
static char o_sql_update_activeuser[] = "update Sacp_ActiveUsers set CurActiveUsers = CurActiveUsers-1 where CurActiveUsers > 0 and scpid = :1 and '1' in (select FirstLifeCall from sacp_basetab_ where isdn = :2)";
代码编译通过并执行成功了,但是表数据没变化,谁知道这个咋回事啊???