- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- [求助] 表属性代码错误 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=160369)
-- 发布时间：2021/1/30 21:10:00
-- [求助] 表属性代码错误
老师，表属性代码错误，请帮忙看一下，谢谢。
Dim cmd As new SQLCommand
cmd.C
Dim dt As DataTable
dt = cmd.ExecuteReader(True)
If e.DataCol.Name = "AssemblingStartingDate" Or e.DataCol.Name = "AssemblingFinishingDate" Or e.DataCol.Name = "QtyCompleted" Or e.DataCol.Name = "Assembler" Or e.DataCol.Name = "AssStatus" Or e.DataCol.Name = "AssStartingScantimes" Or e.DataCol.Name = "WKNumber" Or e.DataCol.Name = "TimeKeeping" Or e.DataCol.Name = "MaterialPreparation" Then
cmd.CommandText = "u pdate ICMO set FHeadSelfJ0193 = a.MaterialPreparation,FHeadSelfJ0194 = a.AssemblingStartingDate,FHeadSelfJ0198 = a.AssemblingFinishingDate,FHeadSelfJ0195 = a.WKNumber,FHeadSelfJ01101 =a.AssStatus,FHeadSelfJ0199 =a.QtyCompleted,FHeadSelfJ0197 =a.TimeKeeping,FHeadSelfJ0196=a.AssStartingScantimes from 生产任务单 As a where a.生产任务单号 = ICMO.FBillNo"
cmd.ExecuteNonQuery
dt.Save()
End If
此主题相关图片如下：捕获.png
[此贴子已经被作者于2021/1/30 21:10:47编辑过]
-- 发布时间：2021/1/31 20:22:00
--
数据库没有生产任务单这个表
-- 发布时间：2021/2/11 13:20:00
--
老师这个表在foxtable中
-- 发布时间：2021/2/16 11:21:00
--
如果是内部表，不需要指定数据源