日终处理报错
<P>嘿嘿 新手哦 今天跟老师一起遇到了个问题，解决了，跟大家分享一下哦。希望看得懂我讲的哦哈哈</P><P><FONT face=宋体><SPAN lang=EN-US style="FONT-SIZE: 10pt">IC</SPAN><SPAN style="FONT-SIZE: 10pt">模块，日终处理的时候发现错误如第一章图。</SPAN></FONT></P><P><FONT face=宋体><SPAN style="FONT-SIZE: 10pt"></SPAN></FONT></P><P><FONT face=宋体><SPAN style="FONT-SIZE: 10pt"><SPAN lang=EN-US><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></SPAN></FONT></P><P><SPAN style="FONT-SIZE: 10pt"><FONT face=宋体>用<SPAN lang=EN-US>TOOLS</SPAN>里的<SPAN lang=EN-US>VRSPY</SPAN>工具跟踪日终处理，日终处理停留在<SPAN lang=EN-US>“</SPAN>正在处理<SPAN lang=EN-US>26-1 </SPAN>发票编号<SPAN lang=EN-US>IN<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="False" SourceValue="200900290" UnitName="”">00200900290”</st1:chmetcnv></SPAN>上如第二张图。<SPAN lang=EN-US><o:p></o:p></SPAN></FONT></SPAN></P><P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"></SPAN></P><P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在数据库中查找表</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">OESHCD</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（即出货成本表）中发票号为</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">IN00200900290</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的数据，并与</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">OESHIH</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（出货主表）的记录进行对比，发现表</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">OESHCD</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">与</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">OESHIH</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中的主键即字段</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">SHIUNIQ</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">相同的记录，发票号竟然不同，这就是错误出现的原因。应该是由于数据量太大，导致数据库读取出现问题，只要将相关记录在</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">OESHCD</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中的发票号改为</SPAN><SPAN lang=EN-US style="FONT-SIZE: 10pt">OESHIH</SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">对应的发票号就可以了。</SPAN></P><P>不好意思,图片上传没有成功,看附件八哈哈:)</P><P> </P><P> </P><P>［此帖子已被 shujiao.pan 在 2009-5-26 21:42:34 编辑过］</P><P>［此帖子已被 shujiao.pan 在 2009-7-8 14:08:19 编辑过］</P><IMG src="attachments/bbsxp/2009-7/20097814850.jpg" border=0><IMG src="attachments/bbsxp/2009-7/2009781492.jpg" border=0><P>［此帖子已被 shujiao.pan 在 2009-7-8 14:09:15 编辑过］</P><p>［此帖子已被 shujiao.pan 在 2009-7-8 14:11:57 编辑过］Re:日终处理报错
很好，图片请重新上传。Re:日终处理报错
<P>收藏!</P>页:
[1]