【结贴】视图的问题**

zfang

楼主，你可以尝试一下抓sql分析一下看看。

dupit

问题是 我这个更新 没有SQL语句 只有视图 的 更新选项 这个属性中的 更新语句 如下

UPDATE TXMB
SET  
JD = :JD  ,
FJD = :FJD  ,
SXH = :SXH  ,
SFHZ = :SFHZ  ,
SFML = :SFML  ,
XMXZ = :XMXZ  ,
CZQD = :CZQD  ,
CZQDMC = :CZQDMC  ,
XMBH = :XMBH  ,
XMMC = :XMMC  ,
XMNR = :XMNR  ,
XMFL = :XMFL  ,
XMLX = :XMLX  ,
EXMXZ = :EXMXZ  ,
EXMCD = :EXMCD  ,
GCZY = :GCZY  ,
JHFY = :JHFY  ,
JHSJ = :JHSJ  ,
BZ = :BZ  ,
XMZT = :XMZT  ,
LCZT = CZT  ,
BZBM = :BZBM  ,
BZR = :BZR  ,
BZSJ = :BZSJ  ,
ZGBM = :ZGBM  ,
ZGGW = :ZGGW  ,
ZGR = :ZGR  ,
JHBM = :JHBM  ,
SSBM = :SSBM  ,
XBBM = :XBBM  ,
KYTZ = :KYTZ  ,
KCTZ = :KCTZ  ,
SQLY = :SQLY  ,
SQZJ = :SQZJ  ,
SQR = :SQR  ,
SQSJ = :SQSJ  ,
KYPZWH = :KYPZWH  ,
KCPZWH = :KCPZWH  ,
HTBH = :HTBH  ,
PFBH = FBH  ,
PFZJ = FZJ  ,
PFSJ = FSJ  ,
YSZJ = :YSZJ  ,
SFTJ = :SFTJ  ,
SFDB = :SFDB  ,
SFKH = :SFKH  ,
SFSJ = :SFSJ  ,
SFFJ = :SFFJ  ,
SFTZ = :SFTZ  ,
SFCLYJ = :SFCLYJ  ,
SFGD = :SFGD  ,
JHKSSJ = :JHKSSJ  ,
JHJSSJ = :JHJSSJ  ,
CLQX = :CLQX  ,
ZGQ = :ZGQ  ,
TZGS = :TZGS  ,
XXJD = :XXJD  ,
TZJD = :TZJD  ,
SGJD = :SGJD  ,
SGDW = :SGDW  ,
SJKSSJ = :SJKSSJ  ,
SJJSSJ = :SJJSSJ  ,
ESBLX = :ESBLX  ,
EDYDJ = :EDYDJ  ,
ESBXH = :ESBXH  ,
ESL = :ESL  ,
EJLDW = :EJLDW  ,
EDJ = :EDJ  ,
EXL = :EXL  ,
EBDRL = :EBDRL  ,
EGCGK = :EGCGK  ,
ESFJDAPXM = :ESFJDAPXM  ,
ESJFS = :ESJFS  ,
EZBFS = :EZBFS  ,
EYSFS = :EYSFS  ,
ESHJFS = :ESHJFS  ,
ESJHS = :ESJHS  ,
ECLGY = :ECLGY  ,
WCQK = :WCQK  ,
EGS = :EGS  ,
JHSSJD = :JHSSJD  ,
EYJKSSJ = :EYJKSSJ  ,
EYJWCSJ = :EYJWCSJ ,
ECZWT = :ECZWT,
EXMJL = :EXMJL,
EXMZG = :EXMZG,
EXMJLGW=:EXMJLGW
WHERE  ( XH = :OLD__XH )

UPDATE TJHXMQD
SET  
SQXXJD = :SQXXJD  ,
SQTZJD = :SQTZJD  ,
JHXXJD = :JHXXJD  ,
JHTZJD = :JHTZJD  ,
SJXXJD = :SJXXJD  ,
SJTZJD = :SJTZJD  ,
SFXS = :SFXS  ,
SQWCZT = :SQWCZT  ,
SQSJWCZT = :SQSJWCZT  ,
SQSJXXJD = :SQSJXXJD  ,
SQSJTZJD = :SQSJTZJD  ,
JHWCZT = :JHWCZT  ,
SJWCZT = :SJWCZT  
WHERE  ( XH = :OLD__XH )

zfang

楼主，我是说你做一下编辑保存，然后抓到这些发往服务端sql语句看看。
或者远程看看。

dupit

我的 插入，更新 语句 都是在 由项目表和计划项目清单 合成的一个数据集 的更新选项属性 里自动生成的 我怎么抓啊

里面插入生成的代码 是这样的
INSERT INTO TXMB
( XH , JD , FJD , SXH , SFHZ , SFML , XMXZ , CZQD , CZQDMC , XMBH , XMMC , XMNR , XMFL , XMLX , EXMXZ , EXMCD , GCZY , JHFY , JHSJ , BZ , XMZT , LCZT , BZBM , BZR , BZSJ , ZGBM , ZGGW , ZGR , JHBM , SSBM , XBBM , KYTZ , KCTZ , SQLY , SQZJ , SQR , SQSJ , KYPZWH , KCPZWH , HTBH , PFBH , PFZJ , PFSJ , YSZJ , SFTJ , SFDB , SFKH , SFSJ , SFFJ , SFTZ , SFCLYJ , SFGD , JHKSSJ , JHJSSJ , CLQX , ZGQ , TZGS , XXJD , TZJD , SGJD , SGDW , SJKSSJ , SJJSSJ , ESBLX , EDYDJ , ESBXH , ESL , EJLDW , EDJ , EXL , EBDRL , EGCGK , ESFJDAPXM , ESJFS , EZBFS , EYSFS , ESHJFS , ESJHS , ECLGY , WCQK , EGS , JHSSJD , EYJKSSJ , EYJWCSJ,ECZWT,EXMJL,EXMZG,EXMJLGW)
VALUES ( :XH , :JD , :FJD , :SXH , :SFHZ , :SFML , :XMXZ , :CZQD , :CZQDMC , :XMBH , :XMMC , :XMNR , :XMFL , :XMLX , :EXMXZ , :EXMCD , :GCZY , :JHFY , :JHSJ , :BZ , :XMZT , CZT , :BZBM , :BZR , :BZSJ , :ZGBM , :ZGGW , :ZGR , :JHBM , :SSBM , :XBBM , :KYTZ , :KCTZ , :SQLY , :SQZJ , :SQR , :SQSJ , :KYPZWH , :KCPZWH , :HTBH , FBH , FZJ , FSJ , :YSZJ , :SFTJ , :SFDB , :SFKH , :SFSJ , :SFFJ , :SFTZ , :SFCLYJ , :SFGD , :JHKSSJ , :JHJSSJ , :CLQX , :ZGQ , :TZGS , :XXJD , :TZJD , :SGJD , :SGDW , :SJKSSJ , :SJJSSJ , :ESBLX , :EDYDJ , :ESBXH , :ESL , :EJLDW , :EDJ , :EXL , :EBDRL , :EGCGK , :ESFJDAPXM , :ESJFS , :EZBFS , :EYSFS , :ESHJFS , :ESJHS , :ECLGY , :WCQK , :EGS , :JHSSJD , :EYJKSSJ , :EYJWCSJ ,:ECZWT,:EXMJL,:EXMZG,:EXMJLGW)

INSERT INTO TJHXMQD
( XH , JHXH , XMXH , SQXXJD , SQTZJD , JHXXJD , JHTZJD , SJXXJD , SJTZJD , BZBM , BZR , BZSJ , SFXS , EBJ , SQWCZT , SQSJWCZT , SQSJXXJD , SQSJTZJD , JHWCZT , SJWCZT )
VALUES ( :XH , :JHXH , :XMXH , :SQXXJD , :SQTZJD , :JHXXJD , :JHTZJD , :SJXXJD , :SJTZJD , :BZBM , :BZR , :BZSJ , :SFXS , :EBJ , :SQWCZT , :SQSJWCZT , :SQSJXXJD , :SQSJTZJD , :JHWCZT , :SJWCZT )

zfang

楼主，这个问题先找你同事看下，如果还是有问题，远程看看。

dupit

我是杭州达普 的 QQ31318252 加我  远程 给你演示看看

zfang

好，稍等。

dupit

怎么还没加我呢

zfang

已经加过你了。刚才在跟你同事沟通。

dupit

OK 结贴了 非常感谢