我调用的某个数据集(t5表)都是用中文的 select t1.FItemID,(t3.FModel*t1.FAuxQty/1000) as dunwei, t3.FName as FItemName, t3.FNumber as FItemNumber, t4.FName as FCusTomName, t2.FDate, t3.F_115, t5.区域 as quyu, t5.起始地 as QSD, t5.起始地经度 as QSDJD, t5.起始地纬度 as QSDWD, t5.目的地 as MDD, t5.目的地经度 as MDDJD, t5.目的地纬度 as MDDWD from ICStockBillEntry t1 left join ICStockBill t2 on t1.FInterID=t2.FInterID inner join t_ICItem t3 on t1.FItemID=t3.FItemID left join t_Organization t4 on t2.FHeadSelfD0134=t4.fitemid left join kehudizhi t5 on t4.FName=t5.客户名称 where t2.FTranType=41 and t1.FSCStockID=882 and CONVERT(VARCHAR(10),t2.fdate,120)='${FDate}' and t3.Fname like '%${Fname}%' and (t4.Fname like '%${FCusTomName}%' or t4.Fname is null) and t2.FCancellation='0' 提示数据类型不匹配 数据类型varchar 和 text 在 equal to 运算符中不兼容 作为新手,请教一下 以上代码怎么修改,谢谢 |
0
|
|