Microsoft Access INSERT INTO错误 [英] Microsoft Access INSERT INTO error

问题描述

Hi feelas，



请帮忙看看下面我的代码...我使用的是Access2003，错误是由于插入到声明中。你能帮我找出下面的代码有什么问题吗？提前致谢。上帝保佑和更多权力！

 Dim dbs As Database 
 Dim cmd As New ADODB.Command 
 Dim strsql As String 
 
 strsql =INSERT INTO PACRLog [PONumber] VALUES'& PONumbertxt.Text& '
 
使用cmd 
 .ActiveConnection = CurrentProject.Connection 
 .CommandText = strsql 
 cmd.Execute 
 End with 

解决方案

你忘了括号&放置括号而不是方括号。并参见下文

 strsql =   INSERT INTO PACRLog < b>（ PONumber ） VALUES （'& PONumbertxt.Text&  '） 

检查语法 SQL INSERT INTO语句 [ ^ ]



并使用参数化查询来避免 SQL注入 [ ^ ]

Hi feelas,

Please help be out see my code below...Im using Access2003 and the error is due to insert into statement. Can you help me out find what's wrong with the code below? Thanks in advance. God bless and more power!

Dim dbs As Database
  Dim cmd As New ADODB.Command
  Dim strsql As String

strsql = "INSERT INTO PACRLog[PONumber] VALUES '" & PONumbertxt.Text & "'"

With cmd
    .ActiveConnection = CurrentProject.Connection
    .CommandText = strsql
    cmd.Execute
End With

解决方案

You forgot parenthesis & place parenthesis instead of square brackets. And See below

strsql = "INSERT INTO PACRLog(PONumber) VALUES ('" & PONumbertxt.Text & "')"

Check the syntax SQL INSERT INTO Statement[^]

And use parametrized queries to avoid SQL Injection[^]

这篇关于Microsoft Access INSERT INTO错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！