Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Update from 2 files |
Sat, Mar 17 2007 11:40 PM | Permanent Link |
"Carlos" | THIS DON'T WORK
update inv i set i.tax1 = i.total *s.tax1 set i.tax2 = i.total * s.tax2 from inv i join system SYSTEM FILE HAVE ONLY ONE RECORD. CARLOS |
Mon, Mar 19 2007 6:18 AM | Permanent Link |
"Jose Eduardo Helminsky" | Carlos
I think you must specify the conditions of join > update inv i > set i.tax1 = i.total *s.tax1 > set i.tax2 = i.total * s.tax2 > from inv i join system update inv i set i.tax1 = i.total *s.tax1 set i.tax2 = i.total * s.tax2 from inv i join system s on (i.field1 = s.field2) Eduardo |
Mon, Mar 19 2007 12:20 PM | Permanent Link |
"Robert" | "Carlos" <carlos.aneses@gmail.com> wrote in message news:902AF97B-9CEF-481B-9ED4-35348A2D9C97@news.elevatesoft.com... > THIS DON'T WORK > update inv i > set i.tax1 = i.total *s.tax1 > set i.tax2 = i.total * s.tax2 > from inv i join system > > SYSTEM FILE HAVE ONLY ONE RECORD. > update inv i set i.tax1 = i.total * s.tax1, i.tax2 = i.total * s.tax2 from inv i, system s It is always a good idea to indicate what it is that is "not working" for you. Robert |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |