error al guardar un xml cfdi 3.3 en un campo blob type 1 segment 80

[gmontes]

listo, despues de quebrarme la cabeza todos estos dias encontre la solucion




End of command usually means that the parser reached the end of the statement while it was still expecting tokens, or reached a parser state where it should be complete but there are still tokens left. The fact you are concatenating values into the query is a red flag. Also the "column 532676549" could be an indication of problem, as that exceeds query length limits (64k in Firebird 2.5 and earlier), and also suggests you have literals that are larger than supported (32k). Mark Rotteveel


https://stackoverflow.com/questions/...e-statement-in


el construir el query con los campos y los valores excedia el limite del largo de este


la solucion es parametrizar el insert o update como en este ejemplo . se timbra correctamente y guarda en mi base de datos

Código Delphi [-]
Close;
               SQL.Clear;
                SQL.Text:= 'UPDATE cfdi_documentos SET  contenido_xml = :Variable_xml where  empresa=''CAMSI''  and tipo=''F'' and documento= :Folio_xml';   

               ParamByName('Variable_xml').AsBlob:= facturaCFDIv33.XML;   //aqui va el xml de 912 lineas               
               ParamByName('Folio_xml').AsString:= sFolio;               
               ExecSQL;                                                               
               Close;

listo, gracias por todo