SQL update w/ multiple parameters
- From: "Robert Sims" <robertsims@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Feb 2008 21:19:23 -0600
What is wrong with the following update statement. I receive the following error: Syntax error in UPDATE statement.
UserSession.adoCmd.CommandText := 'UPDATE Project_Setup1 SET [Contract_Number, ' +
'Contract_Type, Award_Date, Start_Date, Estimated_Completion_Date, Task_Order_Number, '+
'OpNum, Site_City, Site_State, Site_Zip] = :Contract_Number, :Contract_Type, ' +
':Award_Date, :Start_Date, :Estimated_Completion_Date, :Task_Order_Number, ' +
':OpNum, :Site_City, :Site_State, :Site_Zip WHERE Project_Number = :Project_Number';
Any help would be greately appreciated.
-Robert Sims
.
- Follow-Ups:
- Re: SQL update w/ multiple parameters
- From: Helmut Woess
- Re: SQL update w/ multiple parameters
- Prev by Date: Re: D2007 ADO
- Next by Date: Re: SQL update w/ multiple parameters
- Previous by thread: D2007 ADO
- Next by thread: Re: SQL update w/ multiple parameters
- Index(es):