更新中的语法错误。 [英] syntax error in update.

问题描述

更新[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?

推荐答案

你必须删除[TechWriter] ='是'和WHERE子句之间的逗号：

You have to delete the comma between [TechWriter] = 'Yes' and the WHERE clause:

UPDATE [RevsionRecords] SET [VPoME] = 'Yes', [DoTSE] = '', [DoM] = 'Yes', [CI] = '', [MoMC] = '', [MoMP] = '', [MoRD] = '', [FAA] = '', [TechWriter] = 'Yes' WHERE [RevisionNum] = '2015-100')

在WHERE子句之前有一个不必要的逗号，在结束之前有一个右括号...

There is an unnecessary comma before the WHERE clause and a closing parenthesis just before the end...

其中是开头括号（代码

中的

这篇关于更新中的语法错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！