Skip to main content

Im trying to update  query  a Long string in a single cell but getting syntax error eventhough removed special characters and whitespaces

 

 

Example : 

UPDATE DPOs$$] set Count] = $SampleString$, nAttachment Name] ='$UpdateAttachmentName$', ePO Download Status]='$Status.LegacyAutomation:listToString$' where hPO]=$PO_Number$;
 

In '$UpdateAttachmentName$' the values is :Vendor_Order_form_Freshworks_SaaSMQL_042324_East_West_Coast-PO-13087 , Vendor_Order_form_Freshworks_SaaSMQL_042324_Mf_Edu-PO-13087 , PR___17487_Vendor_Order_form_Freshworks_SaaSMQL_042324_East_West_Coast_1docx-PO-13087 , PR___17487_Vendor_Order_form_Freshworks_SaaSMQL_042324_Mf_Edu_1docx-PO-13087

 

 

 

If i remove one Name in the variable its updating but if i add extra its throwing syntax error

Be the first to reply!

Reply