Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#40 VLocator minor SQL Bug Fix

closed
Yves Sandfort
None
5
2006-10-30
2006-10-19
tech8liss
No

2.5.3d 2006-08-10

Component fail to return M_Locator_ID due to SQL typo?
error
Fix (diff format) attached

380c380,383
< .append("WHERE
p.M_Locator_ID=M_Locator.M_Locator_ID AND
s.M_Product_ID=?)")
---
> //<< Halim - bug fix
> // .append("WHERE
p.M_Locator_ID=M_Locator.M_Locator_ID AND
s.M_Product_ID=?)")
> .append("WHERE
p.M_Locator_ID=M_Locator.M_Locator_ID AND
s.M_Product_ID=?)")
> //>> end bug fix

regards

Discussion

  • tech8liss
    tech8liss
    2006-10-19

     
    Attachments
  • tech8liss
    tech8liss
    2006-10-19

    Logged In: YES
    user_id=1238610

    Please use the attached .diff file. Thanks.

     
  • Yves Sandfort
    Yves Sandfort
    2006-10-27

    • assigned_to: nobody --> jjanke
     
  • Yves Sandfort
    Yves Sandfort
    2006-10-27

    Logged In: YES
    user_id=467647

    Needs to be corrected as far as I can see.

    Checked seems okay.

     
  • Jorg Janke
    Jorg Janke
    2006-10-30

    Logged In: YES
    user_id=87038

    I think, I fixed that already

     
  • Jorg Janke
    Jorg Janke
    2006-10-30

    • assigned_to: jjanke --> comdivisionys
     
  • Jorg Janke
    Jorg Janke
    2006-10-30

    Logged In: YES
    user_id=87038

    I think it need to be

    .append("OR EXISTS (SELECT * FROM M_Product p ") // Product Locator
    .append("WHERE p.M_Locator_ID=M_Locator.M_Locator_ID AND p.M_Product_ID=?)")
    .append("OR EXISTS (SELECT * FROM M_Storage s ") // Storage Locator
    .append("WHERE s.M_Locator_ID=M_Locator.M_Locator_ID AND s.M_Product_ID=?))");

     
  • tech8liss
    tech8liss
    2006-10-30

    Logged In: YES
    user_id=1238610

    :) it was an error in cut-paste work.. fixed in the attachment

    Just realized same issue was reported by ptb-tds 2 days
    before my posting. Anyway thanks for incorporating the fix.

    Regards,

     
  • tech8liss
    tech8liss
    2006-10-30

    • status: open --> closed