jccarta


>Can i replace the information in blob field fx_costos in sfixed file without affectin the informacion stored in blob fileld fx_stadisticas in the same sfixed file for other record types.
>
>I Can achieve this using only updtate Sql? assuming of course that I transferred a copy of sfixed file on the site "A" to a file on the site "B" tmp_sfixed .

These questions are different to what you've been asking and easily answered. An SQL update statement can simply modify one column of a table without altering any of the others

This is the example in the manual

UPDATE orders o SET ShipToContact=c.Contact
FROM orders o LEFT OUTER JOIN customer c
ON c.custno=o.custno

so for youself it would be something like

UPDATE sfixed B SET fx_costos = A.fx_costos
FROM sfixed B
LEFT OUTER JOIN sfixedtransfered A ON B.Fx_tipo = A.Fx_tipo AND B.fxcodigo = A.fxcodigo

Roy Lambert [Team Elevate]