Foxtable(狐表)用户栏目专家坐堂 → [求助] 取值


  共有2226人关注过本帖平板打印复制链接

主题:[求助] 取值

美女呀,离线,留言给我吧!
susanhe
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:小狐 帖子:312 积分:2477 威望:0 精华:0 注册:2018/11/22 20:30:00
  发帖心情 Post By:2020/8/22 10:42:00 [只看该作者]

再麻烦老师,修改如下,错误如图,请帮忙再指正一下,谢谢。


For Each rr As Row In Tables("GroupPrice").Rows
   
    rr("FPrioritized") = DataTables("Pricelist").Compute("count(FNumber)","FNumber = rr(FNumber) And FPrioritized= true")

    rr("Suppliers") = DataTables("Pricelist").Compute("count(FNumber)", "FNumber = rr(FNumber) ")
    rr("FLastModifiedDate") = DataTables("Pricelist").Compute("max(FLastModifiedDate)", "FNumber = rr(FNumber) And FPrioritized= true")
   
    Dim dr As DataRow = DataTables("Pricelist").Find( "FNumber = rr(FNumber) And FLastModifiedDate=#" & rr("FLastModifiedDate") & "# And FPrioritized = True")
   
    If dr IsNot Nothing Then
        rr("FPrice") = dr("FPrice")
        rr("FRemark") = dr("FRemark")
        rr("FQuoteTime") = dr("FQuoteTime")
        rr("FName1") = dr("FName")
       
    Else
        rr("FPrice") = Nothing
        rr("FRemark") = Nothing
        rr("FQuoteTime") = Nothing
        rr("FName1") = Nothing
       
    End If
Next



此主题相关图片如下:捕获.png
按此在新窗口浏览图片


[此贴子已经被作者于2020/8/22 10:42:05编辑过]

 回到顶部
总数 14 1 2 下一页