执行的SQL如下, 用于打印产品标签的,但是最后一张Fqty应该为100000的,但报表显示却是10000.
这种情况是偶然发生的.把程序关闭后重运行,打印又可以正常了.另外这个Fqty是有条码的.条码的扫描结果显示也是错误的.
因此,报表模板中的文本控件宽度不足的可能基本排除. select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb1.bmp' as Fpic,1 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb2.bmp' as Fpic,2 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,3 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,4 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,5 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,6 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,7 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,8 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,9 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,10 as ID
union select '批号001' as FLot,'1151' as FDate,'100000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb11.bmp' as Fpic,11 as ID
order by id
这种情况是偶然发生的.把程序关闭后重运行,打印又可以正常了.另外这个Fqty是有条码的.条码的扫描结果显示也是错误的.
因此,报表模板中的文本控件宽度不足的可能基本排除. select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb1.bmp' as Fpic,1 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb2.bmp' as Fpic,2 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,3 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,4 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,5 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,6 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,7 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,8 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,9 as ID
union select '批号001' as FLot,'1151' as FDate,'10000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb3.bmp' as Fpic,10 as ID
union select '批号001' as FLot,'1151' as FDate,'100000' as FQty,'C:\DOCUME~1\pack\LOCALS~1\Temp\bb11.bmp' as Fpic,11 as ID
order by id
如果到不了最后一条记录,那就应该是空.
另外需要补充一下.并不限于最后一个才有问题.
比如产品的型号,最后一两天字母就会莫名其妙地不见了,涉及所有的标签.但所执行的SQL是正常的.真是非常郁闷.难到是FastReport4的漏洞,这洞也太大了点吧?