[求助]枚举值太大，不能适应 96 位十进制 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

1、这样测试有没问题？

Select WOR1.PlannedQty / (Case WHEN WOR1.BaseQty >= 1 Then floor(WOR1.BaseQty) Else 1 End) As 最大毛坯 FROM OWOR INNER JOIN WOR1 ON OWOR.DocEntry = WOR1.DocEntry WHERE OWOR.DocNum = 1252

2、这样测试有没问题？

select max(最大毛坯) from (Select WOR1.PlannedQty / (Case WHEN WOR1.BaseQty >= 1 Then floor(WOR1.BaseQty) Else 1 End) As 最大毛坯 FROM OWOR INNER JOIN WOR1 ON OWOR.DocEntry = WOR1.DocEntry WHERE OWOR.DocNum = 1252) as a

3、这样测试有没问题？

Select max(WOR1.PlannedQty / (Case WHEN WOR1.BaseQty >= 1 Then round(WOR1.BaseQty) Else 1 End)) As 最大毛坯 FROM OWOR INNER JOIN WOR1 ON OWOR.DocEntry = WOR1.DocEntry WHERE OWOR.DocNum = 1252

主题：[求助]枚举值太大，不能适应 96 位十进制