|
....这年头还有什么怪事不会出现........
恢复默认值应该恢复的只是form setting本身,每个form的width是不变的.
比如通过
select U_NAME,ousr.user_code, cprf.width from cprf, OUSR
where FormID = '10003' and ItemID = '7' and ColID = 'Itemname'
and ousr.user_code = '倒霉的用户名' --(或者是cprf.width = 0反查 )
and cprf.usersign = ousr.USERID
总之,也许可能说不定或许大概你会看见width是0
如果是这样,请用户们行行好开开恩,以后手不要那么贱,然后请他们退出系统先.
然后...
update cprf
set cprf.width = 100
from cprf, OUSR
where FormID = '10003' and ItemID = '7' and ColID = 'Itemname'
and ousr.user_code = '倒霉的用户名'
and cprf.usersign = ousr.USERID |
|