狐狸爸爸,我加入进去,提示不存在DATATABLE(“定单”)表,因为我的是窗口中模拟这个,我根本没有把这个表放到FT里呀,该怎么处理
Tables("窗口客户_tblKehu").Fill("select top 100 customer_id as 客户序号,customer_name as 公司名称,customer_number as 编号,address as 地址,creator as 创建者,create_date as 创建日期,ditu_zuobiao as 坐标 ,x,y,zhengjian as 证件 from crm_customer order by customer_id desc","cc",False)
If DataTables("crm_customer").DataRows.Count = 0 Then '如果crm_customer表没有数据
DataTables("crm_customer_linkman").LoadFilter = "crm_customerID Is Null" '不加载crm_customer_linkman
Else
Dim ids As String
For Each dr As DataRow In DataTables("crm_customer").DataRows
ids = ids & ",'" & dr("crm_customerID") & "'"
Next
ids= ids.Trim(",")
DataTables("crm_customer_linkman").LoadFilter = "crm_customerID In (" & ids & ")"
End If
DataTables("crm_customer_linkman").Load()
[此贴子已经被作者于2013-9-4 13:41:40编辑过]