这个错误是代表什么意思啊?!
Project1.exe raise execption class EoleException with message '无法解决 equal to 操作的排序规则冲突。 '
当我执行我的程序的时候就出现以上错,代表什么意思呢?
我的SQL语句是这个: 'Select D.MR_Name,sum(D.MR_Count) from MR_XSStockList_Tab D,MR_XSStock_Tab M where M.MR_OutStockID=D.MR_PriceID and M.MR_OutStockDate <= '+QuotedStr(Eday)+ ' and M.MR_OutStockDate> = '+QuotedStr(SDay)+ ' group by D.MR_Name '
麻烦各位高手帮忙解决下~~~
[解决办法]
是否设置了lookup字段?
将lookupcash为true
[解决办法]
这句sql可以改成
'Select D.MR_Name,sum(D.MR_Count) from MR_XSStockList_Tab D where exists(select 1 from MR_XSStock_Tab M where M.MR_OutStockID=D.MR_PriceID and M.MR_OutStockDate <= '+QuotedStr(Eday)+ ' and M.MR_OutStockDate> = '+QuotedStr(SDay)+ ') group by D.MR_Name '