Update blob field from an on external data source -------------------------------------------------
Key: CORE-3643 URL: http://tracker.firebirdsql.org/browse/CORE-3643 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.0 Environment: linux deb64 and windows Xp Reporter: Luis This query don't work but not error raised (the blob field in the remote host is corrupted) EXECUTE BLOCK DECLARE BLOBFIELD BLOB; DECLARE CONSULTA VARCHAR(5000); BEGIN EXECUTE STATEMENT 'SELECT BLOBFIELD FROM SOMETABLE WHERE ID = 1;' ON EXTERNAL 'localhost/3050:c:\bd.fdb' /*blob from windows xp 32-bit*/ INTO :FOTO; CONSULTA = 'EXECUTE BLOCK (BLOBFIELD BLOB = :BLOBFIELD) AS BEGIN UPDATE SOMETABLE SET BLOBFIELD = :BLOBFIELD WHERE ID = 1; END;'; EXECUTE STATEMENT (:CONSULTA) (BLOBFIELD := :BLOBFIELD ) ON EXTERNAL '82.x.x.x/3050:/bd.fdb'; /*blob destination on linux debian5 64-bit*/ END -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel