MarshallB
Well Known Member
Hi All,
I have a scenario where I'm trying to log some events/data from the P42101. I created a small custom table, and within the ER of the submit order button and another, custom button, I have several Table I/O inserts into my custom table. However, only one or two of the inserts are happening. It appears the execution is happening faster than the IO process can handle. If I run the code in ER debugger it works fine, but left alone several of the inserts are skipped. If I disable the first of the insert statements, the next one below it will run. I can disable/enable the insert statements like this, and make each of them run, but if they're all enabled it doesn't work. I tried explicitly opening/closing at each insert, tried checking for SV_fileIO success etc, but to no avail.
So far all testing has only been local on a dev machine, so maybe the behavior would change if run on the server?
I appreciate any suggestions for making this work.
JDE 9.2
Tools 9.2.1.4
Windows
Sql 2014
I have a scenario where I'm trying to log some events/data from the P42101. I created a small custom table, and within the ER of the submit order button and another, custom button, I have several Table I/O inserts into my custom table. However, only one or two of the inserts are happening. It appears the execution is happening faster than the IO process can handle. If I run the code in ER debugger it works fine, but left alone several of the inserts are skipped. If I disable the first of the insert statements, the next one below it will run. I can disable/enable the insert statements like this, and make each of them run, but if they're all enabled it doesn't work. I tried explicitly opening/closing at each insert, tried checking for SV_fileIO success etc, but to no avail.
So far all testing has only been local on a dev machine, so maybe the behavior would change if run on the server?
I appreciate any suggestions for making this work.
JDE 9.2
Tools 9.2.1.4
Windows
Sql 2014