Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Paris
    Posts
    1

    Question Unanswered: SQL Results not good !

    Hello

    i made a document which explain my problem, it is attached on the post...You can find it here too : http://www.starwars-universe.com/ima...ey/HELP_EN.Zip

    PS : I'm french so i don't speak english very well, sorry

    THANKS in advance for your help
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: SQL Results not good !

    If moving some conditionals around changes the output, it sounds like your Parens aren't lining up the way you wanted. It appears in the first query that the Sales_Org_Code is being evaluated and the Doc_Type_Code is falling under the conditional.

    I think it would be a little easier to trouble shoot of you grab the SQL after it is parsed by BO and sent to the database. That way you can look at how everything is stacking up.

    Hope it helps

  3. #3
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: SQL Results not good !

    Previous post should have read

    It appears in the first query that the Sales_Org_Code is being evaluated and the Doc_Type_Code is falling under the OR condition

    Its Friday morning, and need more caffeine!!!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •