Hi there,
I have a MS access application where I'm trying to merge two databases. When I call the execute function of an ADOCommand I get the following error message: Project ... raised exception class EOleException with message 'Parameter AFR has no default value'.
AFR is actually a value of the "ConsultantID" field in the db table I'm trying to update.
Here is the CommandText of the ADOCommand:
"UPDATE WaterTreatmentWorks SET WorksName =\"" + consultantDataTable->FieldByName("WorksName")->AsString + "\", ConstructionDate =\"" + consultantDataTable->FieldByName("ConstructionDate")->AsString + "\" WHERE ConsultantID = " + consultantID
I'm pretty sure the SQL syntax is correct because it executes fine when none of the values in the "ConsultantID" field in the db table match the consultantID variable in the WHERE clause(if that makes sense). But it keeps giving me the error otherwise...
If anyone could help I would greatly appreciate it!
Thank you,
Andrew
I have a MS access application where I'm trying to merge two databases. When I call the execute function of an ADOCommand I get the following error message: Project ... raised exception class EOleException with message 'Parameter AFR has no default value'.
AFR is actually a value of the "ConsultantID" field in the db table I'm trying to update.
Here is the CommandText of the ADOCommand:
"UPDATE WaterTreatmentWorks SET WorksName =\"" + consultantDataTable->FieldByName("WorksName")->AsString + "\", ConstructionDate =\"" + consultantDataTable->FieldByName("ConstructionDate")->AsString + "\" WHERE ConsultantID = " + consultantID
I'm pretty sure the SQL syntax is correct because it executes fine when none of the values in the "ConsultantID" field in the db table match the consultantID variable in the WHERE clause(if that makes sense). But it keeps giving me the error otherwise...
If anyone could help I would greatly appreciate it!
Thank you,
Andrew