[求助]如何向外部表写入逻辑列? - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim dt As DataTable = DataTables("金蝶银行账")

Dim cmd As New SQLCommand

cmd.C

For Each dr As DataRow In dt.dataRows

cmd.CommandText = "Ins ert In to {TRBankJnl} ([FDATE],[FPERIOD],[FACCTID],[FCYID],[FDEBIT],[FCREDIT],[FEXP],[FORDERID],[FCLOSED],[FPREPARER]) Values(#" & dr("FDATE") & "#," & dr("FPERIOD") & ",'" & dr("FACCTID") & "','" & dr("FCYID") & "'," & dr("FDEBIT") & "," & dr("FCREDIT") & ",'" & dr("FEXP") & "'," & dr("FORDERID") & "," & dr("FCLOSED") & ",'" & dr("FPREPARER") & "')"

cmd.ExecuteNonQuery

上面语句中红色字段[FCLOSED]是逻辑列,去掉就能写入,加上就不能写入.不知错在哪里.

[此贴子已经被作者于2018/11/12 13:49:41编辑过]

主题：[求助]如何向外部表写入逻辑列?