我正在尝试INSERT
使用VB.NET对访问数据库执行查询,并且一直抱怨我有语法错误。我似乎无法弄清楚。如果我在Access本身中运行它,它将起作用。
为了让您了解正在发生的事情,下面是一些调试代码:
Dim params(6) As OleDb.OleDbParameter
params(0) = New OleDb.OleDbParameter("@matchNumber", Integer.Parse(recMatchNumber))
params(1) = New OleDb.OleDbParameter("@teamNumber", Integer.Parse(recTeamNumber))
params(2) = New OleDb.OleDbParameter("@action", recAction)
params(3) = New OleDb.OleDbParameter("@object", recObject)
params(4) = New OleDb.OleDbParameter("@level", recLevel)
params(5) = New OleDb.OleDbParameter("@location", recLocation)
params(6) = New OleDb.OleDbParameter("@time", recTime)
For Each param As OleDb.OleDbParameter In params
Console.WriteLine(command.CommandText)
Console.WriteLine(param.ParameterName)
Console.WriteLine(param.Value)
command.Parameters.Add(param)
Next
结果如下:
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@matchNumber
1
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@teamNumber
50
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@action
Move
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@object
Robot
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@level
0
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@location
Zone
INSERT INTO matchData( matchNumber, teamNumber, action, object, [level], location, [time]) VALUES(@matchNumber,@teamNumber,@action,@object,@level,@location,@time)
@time
Auto
错误是 Syntax error in INSERT INTO statement.
谢谢。
如前所述,对象和动作是保留字,因此您必须在这些名称周围放置方括号:[对象],[动作]等。
有关保留字的完整列表,请参阅Access 2007保留字和符号。
我经常看到的一些常见保留字会引起问题:
通常最好避免将这些单词用作数据库字段的名称。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句