Syntax error in INSERT INTO statement. Pls Help

[wertqt]

Hi ,

I had written a code in C# as below :

string insertString = "INSERT INTO Module_Repair_Info (FailureNo, XmtrType, SerialNo, Hardware Rev, Software Rev, Firmware Rev) VALUES (' ', '" + Model + "', '" + ModuleSerialNumber + "', '" + Hardware + "', '" + Software + "', '" + Firmware + "')";

When the programs reaches this step :

OleDbCommand myCommand = new OleDbCommand(insertString, myConn2);
myCommand.ExecuteNonQuery();

it shows Syntax error in INSERT INTO statement. I am inserting values from Table A into Table B.

I have no idea wat went wrong here. Pls help thanks!

[avkdsiva]

what do you want to insert into the first field, FailureNo??
You are trying to insert ' '

IS it an empty string that you are trying to insert?
IF so, use " " instead of ' '

thanx

[radcaesar]

Insert a line MessageBox.Show (insertString);
Below the insrt command string, it will show you the error.

:)

[wertqt]

Hi there,
Thanks for all the replies! i solved the problem =P

Cheers!

[AricC]

Hi there,
Thanks for all the replies! i solved the problem =P

Cheers!

What was the solution?

[wertqt]

hi AricC ,
i put a sqaure bracket for fields with space between them. For e.g., Hardware Rev, i insert the sq bracket to become [Hardware Rev].
Also, FailureNo is a required field in my database so instead of putting single quote ' ', i insert a space in it to become ' '.

Cheers!