Foxtable(狐表)用户栏目专家坐堂 → [求助]根据附表筛选子表数据,怎么筛选


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

主题:[求助]根据附表筛选子表数据,怎么筛选

帅哥哟,离线,有人找我吗?
wuxianzuoji41
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:四尾狐 帖子:884 积分:7061 威望:0 精华:0 注册:2013/3/5 8:42:00
[求助]根据附表筛选子表数据,怎么筛选  发帖心情 Post By:2013/12/24 11:11:00 [只看该作者]

current时间件里用下面2种方式,获得的结果不一样,谁帮我解决一下是哪个正确还是都不对

方式一、
If DataTables("crm_customer").DataRows.Count = 0 Then '如果baidu_client表没有数据
    DataTables("crm_customer_track").LoadFilter = "track_id Is Null" '不加载baidu_records
Else
    Dim ids As String
    For Each dr As DataRow In DataTables("crm_customer").DataRows
        ids = ids & "," & dr("customer_id")
    Next
    ids= ids.Trim(",")
    DataTables("crm_customer_track").LoadFilter = "customer_id In (" & ids & ")"
End If
DataTables("crm_customer_track").Load()


Dim t_genjin As Table = Tables("窗口客户_tbl_Genjin")
With Tables("窗口客户_tblKehu")
    If .Current Is Nothing Then
        t_genjin.filter="false"     
    Else
        t_genjin.Filter = "customer_id = " & .Current("customer_id")    
     End If
End With


二、sql TABLE方式
Dim aa2 As String="Select* from crm_customer_track where customer_id= " & Tables("窗口客户_tblKehu").Current("customer_id")
Tables("窗口客户_tblCeshi").Fill(aa2,"c2",True)


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