Error executing code: Performing NEXT operation on joined cursor is not allowed.

(0) Share

Report

Posted on by AXGreenHorn

135

So I've been getting the error in the title when I try to run a query. I saw another thread where someone mentioned that the issue for them was that their join statement was incorrect. However, I've gone through the query several times and I can't figure out where it's going wrong.

            ttsBegin;

            select firstOnly forUpdate aHAShippedCartonStaging where aSalesTable.recid == RetailEventNotificationLog.SalesOrder
            join aWHSShipmentTable where aWHSShipmentTable.orderNum == aSalestable.salesId
            join aWHSContainerTable where aWHSShipmentTable.shipmentId == aWHSContainerTable.shipmentId
            join aHAShippedCartonStaging where aHAShippedCartonStaging.cartonId == aWHSContainerTable.containerId;

            aHAShippedCartonStaging.shipmentEmailSent = NoYes::No;
            aHAShippedCartonStaging.update();

            ttsCommit;

774327.1.PNG 4834.2.PNG 1030.3.PNG

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 239,385 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It seems that you forgot to join SalesTable, because you use aSalestable variable in the query but you've never selected it.

By the way, your question isn't very efficient. You fetch all fields from several tables, although you don't need even a single one. You could use update_recordset instead.

Was this reply helpful? Yes No