Error while Execute Non Query

Help
1

I’m getting below error while using update query.
Any idea what is the issue.

“UPDATE Patient_Basic_Info Set First_Name = '”+FirstName+“', Middle_Name = '”+MiddleName+“', Last_Name = '”+LastName+“', Mothers_Maiden = '”+MothersMaiden+“', DOB = '”+DOB+“', Martial_Status = '”+MartialStatus+“',
Height = '”+Height+“', DICOM_ID = '”+Height+“', X_Ray_Num = '”+Height+“', SSN_NO = '”+SSN+“', Gender = '”+Gender+“', Language = '”+Language+“', Weight = '”+Weight+“’ , Address_Line1 = '”+AddLine1+“',
Address_Line2 = '”+AddLine2+“', City = '”+City+“', ZIP = '”+ZIP+“’ ,Zip_Plus = '”+ZipPlus+“', Mobile_Num = '”+MobileNum+“', Email_ID = '”+EmailID+“', Contact_By = '”+ContactBy+“',
State_Name = '”+State+“', Work_Phone = '”+WorkPhone+“', Home_Phone = '”+HomePhone+“', Document_Type = '”+DocumentType+“’
Where Accession_Num = '”+AccessionNum+“')”

image
image767×358 26.1 KB

2

@vaibhav2.chavan - please try to keep entire query string in one line to remove the error…

2 Likes
3

@GBK - Thanks again now its working. Any idea why we have to keep query string in single line?