locked
How to update 1 table but thevalue change is in other table? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1318901999 posted

    Hi, i have a problem of update data which my gridview is displays TechCodeDesc, ModuleCode+ModuleName, staffName,

    Table Module consist of ModuleID, ModuleCode, ModuleName.

    Table ModuleTech consist of ModuleID, TechCodeID.

    when i update ModuleCode+ModuleName in GridView, the ModuleID in ModuleTech will be updated.

    my update statment look like below:

    update ModuleTech set ModuleTech.ModuleID = (select ModuleID from Module where ModuleCode+ModuleName = @moduleDesc)  where ModuleTech.TechCodeID = @TechCodeID

     

    when i excute this statment, all ModuleID with same TechCodeID will update to 1 ModuleID, but i want to update only 1 ModuleID

    Thank you for your all help!

     

     

     

    Wednesday, March 23, 2011 1:10 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1199946673 posted

    update ModuleTech set ModuleTech.ModuleID = (select ModuleID from Module where ModuleCode+ModuleName = @moduleDesc)  where ModuleTech.TechCodeID = @TechCodeID

     

    when i excute this statment, all ModuleID with same TechCodeID will update to 1 ModuleID, but i want to update only 1 ModuleID

    update ModuleTech set ModuleTech.ModuleID = (select ModuleID from Module where ModuleCode+ModuleName = @moduleDesc)  where ModuleTech.ModuleID = @ModuleID

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, March 23, 2011 5:42 AM