问题描述
更新[RevsRecords] SET [VPoME] ='是'，[DoTSE] =''，[DoM] ='是'，[ CI] =''，[MoMC] =''，[MoMP] =''，[MoRD] =''，[FAA] =''，[TechWriter] ='是'，WHERE [RevisionNum] ='2015- 100'）
"UPDATE [RevsionRecords] SET [VPoME] = 'Yes', [DoTSE] = '', [DoM] = 'Yes', [CI] = '', [MoMC] = '', [MoMP] = '', [MoRD] = '', [FAA] = '', [TechWriter] = 'Yes', WHERE [RevisionNum] = '2015-100')"
我在尝试更新访问数据库时出现语法错误vb.net上面的字符串是vb.net传递的实际更新命令。传递空值的问题是什么？在这种情况下，我的代码只有3个字段来填充字符串值yes，因此其他值为null。我在这里做错了什么？
I'm getting a syntax error trying to update access database from vb.net The string above is the actual update command being passed by vb.net. Is the issue in passing the empty values? In this case my code has only 3 fields to populate the string value of "yes" so the other values are null. what am I doing wrong here?
推荐答案
UPDATE [RevsionRecords] SET [VPoME] = 'Yes', [DoTSE] = '', [DoM] = 'Yes', [CI] = '', [MoMC] = '', [MoMP] = '', [MoRD] = '', [FAA] = '', [TechWriter] = 'Yes' WHERE [RevisionNum] = '2015-100')
中的
这篇关于更新中的语法错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！