Insert Into Syntax error (missing operator) in query expression

[jgaylord]

Does anyone see what I am doing wrong?
I can Insert a single field.... But when I try and insert 2 fields I get this error. Syntax error (missing operator) in query expression I am trying to do this in VB 2005.


InsertCmd = New System.Data.OleDb.OleDbCommand("Insert Into Result (Ani, Xdate, Cdate, Xamount, Camount, Difference) Values ('" & txtAni.Text & "'," & txtXdate.Text & ",'" & txtCDate.Text & ",'" & txtXAmount.Text & ",'" & txtCAmount.Text & ",'" & txtDifference.Text & "')", dbconnection)
InsertCmd.ExecuteNonQuery()

 

[gmmastros]

Your apostrophes are all whacky.

Try...

InsertCmd = New System.Data.OleDb.OleDbCommand("Insert Into Result (Ani, Xdate, Cdate, Xamount, Camount, Difference) Values ('" & txtAni.Text & "','" & txtXdate.Text & "','" & txtCDate.Text & "','" & txtXAmount.Text & "','" & txtCAmount.Text & "','" & txtDifference.Text & "')", dbconnection)

Hint: When you have these problems, it's usually a good idea to temporarily display the SQL query so you can copy/paste it to Query Analyzer.

p.s. Look up SQL Injection and you should be using a command object to safeguard against the 'apostrophe problem'


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jgaylord]

THANK YOU That worked perfectly! I dont understand what your talking about with the Query Analyzer... But I will take your advice and look it up. Thanks a Million!

 

[gmmastros]

Query Analyzer is an application that ships with SQL Server 2000. If you are using SQL Express or SQL Server 2005, then you would be using the SQL Server Management Studio (SSMS).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom