Method:Classic General Q&A

Re: Action to loop an empty Grid (PurchaseOrderLine), Failed to copy my PUrchaseOrder Screen to another

Method_Jim — Wed, 30 Sep 2015 12:25:58 GMT

We just wanted to confirm that we're on it, and will get back shortly with an update.

-Method Team

Re: Action to loop an empty Grid (PurchaseOrderLine), Failed to copy my PUrchaseOrder Screen to another

alexhuang — Wed, 30 Sep 2015 04:39:35 GMT

I think I already see something wrong in my database, and that may be caused by this issue. I also deactive all my users at this moment, hopefully, all database can be recovered.

Alex

Re: Action to loop an empty Grid (PurchaseOrderLine), Failed to copy my PUrchaseOrder Screen to another

Blake C — Wed, 30 Sep 2015 01:24:45 GMT

Here's the thread I have going on the issue. https://www.method.me/cs/forums/t/7891.aspx

You can see I posted the SQL that shows the unconstrained query resulting in a full table loop. Freaks me out...if I have any updates executing inside an unconstrained grid loop...that's potentially a VERY damaging bug/issue. Hopefully I'm overreacting/not fully understanding what's going on but right now I've deactivated all my users (20 in total) until I'm confident the issue is resolved.

Re: Action to loop an empty Grid (PurchaseOrderLine), Failed to copy my PUrchaseOrder Screen to another

Blake C — Tue, 29 Sep 2015 23:13:19 GMT

There's definitely a problem with the Start Loop Through Grid action. I'm seeing similar behavior

Action to loop an empty Grid (PurchaseOrderLine), Failed to copy my PUrchaseOrder Screen to another

alexhuang — Tue, 29 Sep 2015 20:54:58 GMT

Hi,

Just today, I met an issue that "Start Loop Grid" try to loop an empty grid, and no clue how it happened.

The scanario is like:

1. in my Purchase Order screen, clear and new in order to create a new PO. (this is pretty the same as stock PO screen, with PO list and POLine grid)

2. Once users select a vendor from drop down list, it will trigger a action list: In this action list, it will try to loop POLine Grid and do some check. For a PO screen without any PO item, I assume there is no codes been run in this Grid loop.

3. In my case, actually, the codes inside this Grid loop is executed.

Again, it just happened today, and it totally blocks our PO creation flow. Any idea?

And, if I tried to copy my customied purchase order screen to another one, it failed.

Alex