Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
What's wrong with this? |
Tue, Sep 18 2007 10:40 AM | Permanent Link |
Abdulaziz Jasser | This UPDATE clause use to work with DBISAM3:
UPDATE RAM.Name158378 A SET A.ItemNo = B.ItemNo, A.ItemName = B.ItemName_A FROM RAM.Name158378 LEFT OUTER JOIN TB_Items B ON B.BranchSysNo = A.BranchSysNo AND B.YearSysNo = A.YearSysNo AND B.ItemSysNo = A.ItemSysNo |
Tue, Sep 18 2007 3:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Abdulaziz,
<< This UPDATE clause use to work with DBISAM3: >> See here: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=19&msg=1020&page=1#msg1020 -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 19 2007 8:28 AM | Permanent Link |
Abdulaziz Jasser | Tim,
<<See here: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=19&msg=1020&page=1#msg1020>> Sorry Tim, but I cannot find a way to use correlated sub-query to update two fields. In the example you wrote you were updating one field only with a static value (TRUE). But in my case I am updating two fields from another table. |
Wed, Sep 19 2007 9:31 AM | Permanent Link |
Chris Erdal | Perhaps the OUTER is part of the problem?
I've not yet got stuck into EDB, but I seem to recall encountering this with DBISAM4. -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3) |
Wed, Sep 19 2007 1:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Abdulaziz,
<< Sorry Tim, but I cannot find a way to use correlated sub-query to update two fields. In the example you wrote you were updating one field only with a static value (TRUE). But in my case I am updating two fields from another table. >> Could you post the original query ? I can then give you a modified version that does what you want. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 19 2007 1:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Abdulaziz,
Never mind my last request - I forgot that you posted the query already. Here's the EDB version: UPDATE RAM.Name158378 A SET A.ItemNo = (SELECT B.ItemNo FROM TB_Items B ON B.BranchSysNo = A.BranchSysNo AND B.YearSysNo = A.YearSysNo AND B.ItemSysNo = A.ItemSysNo), A.ItemName = (SELECT B.ItemName_A FROM TB_Items B ON B.BranchSysNo = A.BranchSysNo AND B.YearSysNo = A.YearSysNo AND B.ItemSysNo = A.ItemSysNo) -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 19 2007 5:08 PM | Permanent Link |
Abdulaziz Jasser | Tim,
<<Never mind my last request - I forgot that you posted the query already. Here's the EDB version:>> Thanks, I made small change to it to make it work. Here is the correct one: UPDATE RAM.Name158378 A SET A.ItemNo = (SELECT B.ItemNo FROM TB_Items B WHERE B.BranchSysNo = A.BranchSysNo AND B.YearSysNo = A.YearSysNo AND B.ItemSysNo = A.ItemSysNo), A.ItemName = (SELECT B.ItemName_A FROM TB_Items B WHERE B.BranchSysNo = A.BranchSysNo AND B.YearSysNo = A.YearSysNo AND B.ItemSysNo = A.ItemSysNo) |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |