FastReport SQL结果值与报表显示值不一致?

安涛声依旧 2011-12-17 12:21:26

执行的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

...全文

188 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

andylist 2012-01-17

打赏
举报

打条码时出问题还没遇到过，不过我用的是2.52和3.25这两个版本的

sundayzhao 2011-12-17

打赏
举报

应该不会吧，你把条码去掉，只显示编号看看

安涛声依旧 2011-12-17

打赏
举报

帖子要沉下去了. 有没有人遇到过这情况呢? 发表下看法呀. 很郁闷呀.

安涛声依旧 2011-12-17

打赏
举报

错字更正

错误:最后一两天字母就会莫名其妙地不见了
更正:最后一两个字母就会莫名其妙地不见了

补充说明,以上所说的异常都是偶然事件.无任何征兆.

安涛声依旧 2011-12-17

打赏
举报

[Quote=引用 4 楼 kaikai_kk 的回复:]
你给的值是多少,他显示的就是什么条码
是否有其它的处理代码,比如移到不到最后一条记录等
[/Quote]

如果到不了最后一条记录,那就应该是空.
另外需要补充一下.并不限于最后一个才有问题.
比如产品的型号,最后一两天字母就会莫名其妙地不见了,涉及所有的标签.但所执行的SQL是正常的.

真是非常郁闷.难到是FastReport4的漏洞,这洞也太大了点吧?