=”UPDATE documents SET igv_doc = ‘” & 0 & “‘ WHERE id_agree = ‘” & ENTERO(A2) & “‘ and number_doc = ‘” & SUSTITUIR(E2;”‘”;”””) & “‘ ;”
Two columns
=”UPDATE documents SET igv_doc = ‘” & 0 & “‘ WHERE id_agree = ‘” & SUSTITUIR(B2;”‘”;”””) & “‘ and sap_doc = ‘” & SUSTITUIR(S2;”‘”;”””) & “‘ ;”
=”UPDATE documents SET number_doc = ‘” & P2 & “‘, sap_doc = ‘” & S2 & “‘ WHERE id_agree = ‘” & SUSTITUIR(A2;”‘”;”””) & “‘ and number_doc = ‘” & SUSTITUIR(O2;”‘”;”””) & “‘ ;”
admin