数据被其他用户修改了

查查

数据被其他用户修改了; 数据被其他用户删除了。
请问一下，我想看一下WHERE后面哪些FIELDS变了，在哪 里看到这些CONTACT_old值 ？追加：我测试了：如果用WINDOWDIALOG做的更改，一次改了多个值 ，就提示上面错误，如果手工一个字段一个字段的改，保存是没有问题的。




UPDATE SOH SOH SET SOH.CONTACT = :CONTACT_new, SOH.CURR_CODE = :CURR_CODE_new, SOH.CUST_ADD_DESCC = :CUST_ADD_DESCC_new, SOH.CUST_DESCC = :CUST_DESCC_new, SOH.FAX = :FAX_new, SOH.MOBILE = :MOBILE_new, SOH.SALES_CODE = :SALES_CODE_new, SOH.TEL = :TEL_new  WHERE SOH= :SOH_old AND SOH.APPR_DATE = :APPR_DATE_old AND SOH.APPR_DATE_FST = :APPR_DATE_FST_old AND SOH.APPR_FLAG = :APPR_FLAG_old AND SOH.APPR_USER = :APPR_USER_old AND SOH.BYORDER is null  AND SOH.B_CODE = :B_CODE_old AND SOH.CODEING is null  AND SOH.COMP_CODE is null  AND SOH.CONTACT = :CONTACT_old AND SOH.CURR_CODE = :CURR_CODE_old AND SOH.CUST_ADD_CODE is null  AND SOH.CUST_ADD_DESCC = :CUST_ADD_DESCC_old AND SOH.CUST_CODE = :CUST_CODE_old AND SOH.CUST_DESCC = :CUST_DESCC_old AND SOH.CUST_PO is null  AND SOH.FAX is null  AND SOH.FEE1 is null  AND SOH.FEE2 is null  AND SOH.FLOWREMARK1 is null  AND SOH.FLOWREMARK2 = :FLOWREMARK2_old AND SOH.FLOWSTATUS = :FLOWSTATUS_old AND SOH.F_SO_NO is null  AND SOH.M400 is null  AND SOH.MOBILE = :MOBILE_old AND SOH.MRPAREA is null  AND SOH.ORD_ID = :ORD_ID_old AND SOH.OURMODEL is null  AND SOH.PATHPIC is null  AND SOH.PAY_CODE = AY_CODE_old AND SOH.PCFLAG is null  AND SOH.PCREMARK is null  AND SOH.PCTYPE = CTYPE_old AND (SOH.PRDLEVEL is null OR SOH.PRDLEVEL = '') AND SOH.REMARK is null  AND SOH.SALES_CODE = :SALES_CODE_old AND SOH.SO_NO = :SO_NO_old AND SOH.SYSDATE = :SYSDATE_old AND (SOH.SYSINFO is null OR SOH.SYSINFO = '') AND SOH.SYSUSER = :SYSUSER_old AND SOH.TAX_RATE is null  AND SOH.TEL is null  AND SOH.TOPRDFLAG is null  AND SOH.TRAN_DATE = :TRAN_DATE_old AND SOH.TZ1 is null  AND SOH.TZ2 is null  AND SOH.TZ3 is null  AND SOH.VER_DESC is null  AND SOH.YOURMODEL is null  AND SOH.YOURSERIAL is null  AND SOH.YOURSIZE is null  AND SOH.version = :version_old;

jishuang

保存前输出看看
http://bbs.wex5.com/forum.php?mo ... 6&pid=164970552

查查

这个_old是指保存前 数据库里的值 吧，不是界面值，那我直接在保存前查数据 库就可以了，是吧？

jishuang

可以