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 9 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 9 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 8 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 8 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