Foxtable(狐表)用户栏目专家坐堂 → 调用查询表时报错没有某一列


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

主题:调用查询表时报错没有某一列

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


加好友 发短信
等级:超级版主 帖子:106566 积分:541995 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2021/9/23 10:51:00 [只看该作者]

哪一个MessageBox.Show可以弹出来?

'获取大膜生产计划单列表数据
Dim lstFilter As String = args(0) '列表条件
MessageBox.Show(lstFilter)
If lstFilter = "" Then
    lstFilter = "isnull(bPrint,0) = 0 and isnull(bComplete,0) = 0"
Else 
    lstFilter = "isnull(bPrint,0) = 0 and isnull(bComplete,0) = 0 and " & lstFilter 
End If
MessageBox.Show(0)
'抽取数据(库存匹配)
Dim jb As new SQLJoinTableBuilder("大膜生产计划单列表","V_sc_BigFilmMake_List")
jb.ConnectionName = "DB"
jb.AddCols("_Identify","iID","cCode","dDate","cMachineCode","cTeamCode","cType","cInvCode","cInvName","iThick","iWidth","iLength","cNo","iMakeOrder","bComplete","bPrintOrder","iCompleteQuantity","dDownLineDate","dDownLineDateTime","cBarcode","iWeight","bPrint","cVerifier","dMakeDate","formulaCode","technologyCode")
'jb.AddCols("配方名称","工艺序号")
jb.Filter = lstFilter
jb.Build()
MessageBox.Show(1)
DataTables("大膜生产计划单列表").DataCols.Add("配方名称",Gettype(String),50)
DataTables("大膜生产计划单列表").DataCols.Add("工艺序号",Gettype(String),50)
MessageBox.Show(2)

 回到顶部