SQL Query Syntax Error

[Deecrypt]

Hi,
I hope Im posting in the right newsgroup. I am trying to insert the
result
of the below SQL query in my Access 2003 table. All the fields in this
table
are of type Number. I'm picking up the value of a dropdownlist box and

insert the relevant values in one row of the table.

if (painPresentComboBox.Text == "RUQ")
{
int painPresent = 301717006;
string assessmentID = assessmentNoTextBox.Text;
Convert.ToInt32(assessmentID);
string insertAssessmentData = "INSERT INTO
abdominalpainassessmentrecords (assessment_id, aap_key, concept_id,
attribute, value) VALUES ('" + assessmentID + "', '1', '21522001',
'363698007', '" + painPresent + "')";

OleDbCommand insertAssessment = new
OleDbCommand(insertAssessmentData, o);
insertAssessment.ExecuteNonQuery();
}
Please Help. Desperate beyond belief
Khurram

[Steve Barnett]

If these are all "number" type, why are you inserting strings? You might
want to start by removing the quotes around the values you're inserting.

Steve
"Deecrypt" <kn*****@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...

Hi,
I hope Im posting in the right newsgroup. I am trying to insert the
result
of the below SQL query in my Access 2003 table. All the fields in this
table
are of type Number. I'm picking up the value of a dropdownlist box and

insert the relevant values in one row of the table.

if (painPresentComboBox.Text == "RUQ")
{
int painPresent = 301717006;
string assessmentID = assessmentNoTextBox.Text;
Convert.ToInt32(assessmentID);
string insertAssessmentData = "INSERT INTO
abdominalpainassessmentrecords (assessment_id, aap_key, concept_id,
attribute, value) VALUES ('" + assessmentID + "', '1', '21522001',
'363698007', '" + painPresent + "')";

OleDbCommand insertAssessment = new
OleDbCommand(insertAssessmentData, o);
insertAssessment.ExecuteNonQuery();
}
Please Help. Desperate beyond belief
Khurram

[Deecrypt]

Thank you Steve,

Problem solved. although i also had to take out all the field names
too. Seems Access 2003 does not like field names if the entire row is
going to be populated.

cheers

Khurram

Steve Barnett wrote:

If these are all "number" type, why are you inserting strings? You might
want to start by removing the quotes around the values you're inserting.

Steve
"Deecrypt" <kn*****@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...

Hi,
I hope Im posting in the right newsgroup. I am trying to insert the
result
of the below SQL query in my Access 2003 table. All the fields in this
table
are of type Number. I'm picking up the value of a dropdownlist box and

insert the relevant values in one row of the table.

if (painPresentComboBox.Text == "RUQ")
{
int painPresent = 301717006;
string assessmentID = assessmentNoTextBox.Text;
Convert.ToInt32(assessmentID);
string insertAssessmentData = "INSERT INTO
abdominalpainassessmentrecords (assessment_id, aap_key, concept_id,
attribute, value) VALUES ('" + assessmentID + "', '1', '21522001',
'363698007', '" + painPresent + "')";

OleDbCommand insertAssessment = new
OleDbCommand(insertAssessmentData, o);
insertAssessment.ExecuteNonQuery();
}
Please Help. Desperate beyond belief
Khurram