![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 11 of 11 total |
![]() |
Mon, Aug 26 2013 1:06 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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] |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |