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'麻烦各位高手帮忙解决下~~~
将lookupcash为true
'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'