On 07/26/2013 04:37 PM, Charlie Noah wrote:
POLREC<6> is the unit price of the line item. When it was entered
earlier or just now on the fly, my input routine required numeric and I
filter for unprintables. So they can't get to receiving without a
numeric price, though it could be zero.
I think Bob may have a good troubleshooting technique here. It would
be simple to eliminate causes. Line 107 has a couple of potential
0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC<6>)
I have seen these 3 situations in more than 1 MV implementation/flavor -
1. If POLREC<6> is null, an empty value won't be inserted, throwing
associated values out of sync. Fix by prefixing or suffixing POLREC<6>
with a character that won't be in the data, then converting it out later.
2. INSERT sometimes doesn't like delimited source. Fix by moving
POLREC<6> to a variable and inserting that.
I can try this. The intermittence is still troubling.
Should not be possible unless I've stepped on it through miscoding in
some other programs.
3. If POLREC<6> has multivalues itself, that presents a whole
different problem. Check it first.
All these things can be checked in a little test program in just a few
minutes, and a safer coding technique used.
U2-Users mailing list