Ошибка синтаксиса

Пятница, 11 Марта 2016 г. 07:19 + в цитатник

Добрый день, подскажите где собственно ошибка синтаксиса?
incorrect syntax near ','.

Set cnRecordset = cn.Execute("Update dbo.DogovorPlan Set Year= " & Y & " ,kod_25='" & kod25 & "',kod_usluga='" & usluga & "',kod_urovuslug='" & urov & "',kod_12='" & kod12 & "',kod_52='" & kod_52 & "',kod_33='" & kod33 & " ', " _
& " kod_39='" & kod39 & "',kod_47='" & kod47 & "',kod_103='" & kod103 & "',kod_24='" & kod24 & "',kod_AFE='" & AFE & "',kod_Cdelka='" & cdelka & "',kod_StatBud='" & sbud & "',kod_edizm='" & edizm & "',cost='" & cost & "',coefficient='" & coef & "', " _
& " volume01 ='" & v01 & "',volume02='" & v02 & "',volume03='" & v03 & "',volume04='" & v04 & "',volume05='" & v05 & "',volume06='" & v06 & "',volume07='" & v07 & "',volume08='" & v08 & "',volume09='" & v09 & "',volume10='" & v10 & "',volume11='" & v11 & "', " _
& " volume12='" & v12 & "',sum01='" & s01 & "',sum02='" & s02 & "',sum03='" & s03 & "',sum04='" & s04 & "',sum05='" & s05 & "',sum06='" & s06 & "',sum07='" & s07 & "',sum08='" & s08 & "',sum09='" & s09 & "',sum10 ='" & s10 & "',sum11='" & s11 & "',sum12='" & s12 & "',totalVolume='" & totalv & "', " _
& " totalSum='" & totals & "',kod_kurator ='" & kurat & "',kod_manager='" & manag & "',type_activ='" & activ & "',Kod_18='" & kod18 & "',nameUslugi='" & nameUs & "',kod_upr='" & upr & "',kod_13='" & kod13 & "',recoverable='" & recover & "',numberLot='" & lot & "',ZKprotocol='" & zk & "',procNDS='" & nds & "', " _
& " NumDogKurator='" & dkur & "' , valuta='" & valuta & "' where dbo.DogovorPlan.idPlan='" & idp & "' ")