数据库用Paradox,数据驱动用BDE,在用SQL(select)统计一个数据表的数据时,有时会得到一个错误的结果。但绝大部分情况下会得到正确的结果。本人怀疑BDE 的SQL缓存出错,但找到不解决方法。试过每次查询关闭Query,也加大BDE的缓冲,都还会有这样的情况。各位有什么方法可以清除SQL的缓存?或检查缓存
SQL:
select OperatorItem, Recordtype, RecordState, count(Account) as Cnt, sum(Amount) as Amt, sum(MngAmount) as MngAmt, sum(Poundage) as pdg, sum(Deposit) as dps, sum(CostPrice) as csp from Record group by OperatorItem, RecordType, RecordState
SQL:
select OperatorItem, Recordtype, RecordState, count(Account) as Cnt, sum(Amount) as Amt, sum(MngAmount) as MngAmt, sum(Poundage) as pdg, sum(Deposit) as dps, sum(CostPrice) as csp from Record group by OperatorItem, RecordType, RecordState
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货