Syntax Error in Insert Into Statement VB.net

Question

I'm having the following Error Message on data insertion: Syntax Error in Insert into Statement

Can anyone suggest what I am doing wrong please?

Remark: Field [No] is Primary Key and Data Type is Auto-Increment.

    con.Open()
    Dim tblRoom_Add As String

    tblRoom_Add = "INSERT INTO tblRoom1(No ,Room ,Check_In ,Check_Out ,User ,Price) VALUES " & _
   "('1', '1A', '10-5-2014', '10-6-2014', 'NaNa', '45')"

    Dim InsertInvoice = New OleDbCommand
    InsertInvoice = New OleDbCommand(tblRoom_Add, con)
    InsertInvoice.ExecuteNonQuery()

Which DBMS is this? user is a keyword in SQL Server, so you would need to escape it like [user]. — shree.pat18
– shree.pat18, Commented Aug 13, 2014 at 8:22

Tim Schmelter · Accepted Answer · 2014-08-13 10:33:59Z

1

If this is MS Access NO and USER are reserved words. You either could use a differnt column name or wrap them in brackets[]

INSERT INTO tblRoom1([No], ...., [User], ...

Access 2007 reserved words and symbols

edited Aug 13, 2014 at 10:33

answered Aug 13, 2014 at 8:23

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Youness · Accepted Answer · 2014-08-13 08:21:44Z

0

its not like mysql integers and numbers should not be surronded by ' try this :

 tblRoom_Add = "INSERT INTO tblRoom1(No ,Room ,Check_In ,Check_Out ,[User] ,Price) VALUES (1, '1A', '10-5-2014', '10-6-2014', 'NaNa', 45)"

answered Aug 13, 2014 at 8:21

Youness

1,4951 gold badge9 silver badges21 bronze badges

Collectives™ on Stack Overflow

Syntax Error in Insert Into Statement VB.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related