Open Forum

Expand all | Collapse all

Error when combining vendors Subquery returned more than 1 value.

  • 1.  Error when combining vendors Subquery returned more than 1 value.

    Posted 14 days ago

    When attempting to combine a vendor the following error occurrs.

    Subquery returned more than 1 value.  This is not permitted when the subquery follows =,!=…..;etc

    Anyone know where to start looking?  I have used this tool for years without a hitch.

    Vendor Combiner / Modifier error




    ------------------------------
    Chuck Curtiss
    IT Mgr.
    BNI Coal, Ltd.
    Center ND
    ------------------------------


  • 2.  RE: Error when combining vendors Subquery returned more than 1 value.

    TOP CONTRIBUTOR
    Posted 13 days ago
    You need to move the error message window to view what is hidden in the main window.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------



  • 3.  RE: Error when combining vendors Subquery returned more than 1 value.

    Posted 13 days ago


    ------------------------------
    Chuck Curtiss
    IT Mgr.
    BNI Coal, Ltd.
    Center ND
    ------------------------------



  • 4.  RE: Error when combining vendors Subquery returned more than 1 value.

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Hi Chuck,

    Is there another error that comes up after closing the one in the screenshot?

    At any rate, see if rebuilding the PSTL stored procs makes a difference... click on the button on the lower left side of the PSTL main window.





    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role