主题：[求助]drawcell中效率太低了 有没有别的办法啊

 那试试这样改，再不行，就上传例子

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:管理项目2.foxdb

做了个简单例子

窗口表中加载表A时 增加辅助列，

表A相当于父表，表B相当于子表，

要求表A中对应的子表表B中的数据在表C中的数量作比较，如果表B中的数量>表C中的数量，同时，表B的日期又刚好和今天日期相差3天时，表A的辅助列就填充上内容

请领导帮忙看看 非常感谢

个人感觉，还不如做一张订单明细的查询表,把时间差算好，做好标记，用订单号或订单ID ,和订单表关联，同步加载来的方便。

任何东西，合适就好。

 呃，你表里面的数据就是查不到对应值的才对啊。

 代码，如下

Select [_Identify],订单号,(Select DISTINCT 订单号 from {表B} where {表a}.订单号 = {表B}.订单号 and {表B}.数量 - (Select sum(数量) from {表C} where ID = {表B}.[_Identify]) > 0 And DATEDIFF("d",now(),{表B}.日期) between 0 And 3) As 辅助 from {表A}

改了下日期 可以正常显示了，但是想不通项目中为何不行！纳闷了啊！！！！思路一模一样的

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:管理项目2.foxdb

select [_Identify],OrderNumber,OrderDate,Supplier,InvoiceNumber,InvoiceDate,UserName,Status,(Select DISTINCT OrderNumber from {Purchase_Orders} where {Purchase_Orders}.OrderNumber = {Purchase_List}.OrderNumber And (Select Status from {Purchase_List} where OrderNumber = {Purchase_Orders}.OrderNumber) = '采购中' and {Purchase_Orders}.Quantity - isnull((select sum(Quantity) from {IQC_Details} where Identify = {Purchase_Orders}.[_Identify]),0) > 0 And DATEDIFF("d",GETDATE(),{Purchase_Orders}.DeliveryDate) between 0 And 3) As day1,(Select DISTINCT OrderNumber from {Purchase_Orders} where {Purchase_Orders}.OrderNumber = {Purchase_List}.OrderNumber And (Select Status from {Purchase_List} where OrderNumber = {Purchase_Orders}.OrderNumber) = '采购中' and {Purchase_Orders}.Quantity - isnull((select sum(Quantity) from {IQC_Details} where Identify = {Purchase_Orders}.[_Identify]),0) > 0 And DATEDIFF("d",GETDATE(),{Purchase_Orders}.DeliveryDate) < 0) As day2 from {Purchase_List}

问题已解决