在线设计器 验证select报错,本地设计器不报错,报错内容如下:{"Error":"ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.18]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \u0027\u7C73\u0022),CONCAT(round(t1.\u0060\u96F6\u4EF6\u9AD8\u5EA6\u0060*t1.\u0060\u96F6\u4EF6\u6570\u91CF\u0060 *t.\u0060\u6570\u91CF\u0060/1000,3),\u0022\u7C73\u0022\u0027 at line 36","ErrorCode":"UnknownError"}
第36行报错,报错代码:
select t.`板件ID`,
GetDataItemDetails("product-type", t.`产品类型`) AS 产品类型,
GetDataItemDetails("produce_line_type", t.`产品生产类型`) AS 产品生产类型,
GetDataItemDetails("material-grain-type", t.`正面纹理`) AS 正面纹理,
t.`颜色名称`,
t.`板件名称`,
t.`板件型号`,
t.`宽度`,
t.`高度`,
t.`厚度`,
t.`数量` AS 块数,
t.`主项材料名称` AS 材料名称,
t.`开门方向`,
t.`边型`,
t.`特殊说明` AS 板件备注,
t.`面积`,
t.`长度`,
t.`个数`,
case
when t.`面积` !=0 then CONCAT(round(t.`面积`/10000 * t.`数量`,4),"㎡")
when t.`长度` !=0 then CONCAT(round(t.`长度`/1000 * t.`数量`,3),"米")
else
CONCAT(t.`个数`*t.`数量`,"个")
end 数量,
t1.`零件ID`,
t1.`零件名称`,
t1.`零件编码`,
t1.`零件宽度`,
t1.`零件高度`,
0 + CAST(t1.`零件深度` AS CHAR) AS 零件深度,
t1.`零件数量`,
case
when t1.`零件类型`=11 then ""
when t.`产品生产类型`=1 AND t1.`零件类型`=2 then
if(t1.`零件宽度`>t1.`零件高度`,CONCAT(round(t1.`零件宽度`*t1.`零件数量` *t.`数量`/1000,3),"米"),CONCAT(round(t1.`零件高度`*t1.`零件数量` *t.`数量`/1000,3),"米"))
else
CONCAT(round(t1.`零件宽度` *t1.`零件高度` * t1.`零件数量` *t.`数量`/1000000,4),"㎡")
end 零件计价数量,
case
when t1.`零件类型`=11 then ""
when t.`产品生产类型`=1 AND t1.`零件类型`=2 then
if(t1.`零件宽度`>t1.`零件高度`,t1.`零件宽度`*t1.`零件数量` *t.`数量`/1000,t1.`零件高度`*t1.`零件数量` *t.`数量`/1000)
else
t1.`零件宽度` *t1.`零件高度` * t1.`零件数量` *t.`数量`/1000000
end 零件计价数量2,
t1.`零件材料`,
t1.`特殊说明`,
t2.`材料名称` AS 零件材料名称,
GetDataItemDetails("dis-part-type",t1.`零件类型`) AS 零件类型,
GetDataItemDetails("dis-rule-grain", t1.`零件纹理`) AS 零件纹理,
CONCAT(t.`选项卡下标`+1,"-",t.`排序码`) AS 板件序号,
t.`板件参数`
from `生产单板件表` t
LEFT JOIN `生产单零件表` t1 ON t1.`板件ID`=t.`板件ID` AND t1.`零件类型` in(1,2,11)
LEFT JOIN `材料信息` t2 ON t1.`零件材料`=t2.`材料ID`
where t.`订单ID`=? AND t.`产品类型` =8 AND t.`产品生产类型`=1
order by t.`排序码`,t1.`排序码`
第36行报错
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图