Multivalue Xlate Problem (AREV Specific)
At 07 JUL 1999 09:44:38AM Mike Daniel rendermegone@earthlink.net wrote:
Thanks in advance to anyone that can help,
have customer add in cust window it is MV with only 1 entry on line 1
in the invoice screen have cust add xlated but the single line of
the add is repeting itself, why? and how do you fix?
Mike Daniel
Thanks again.
At 07 JUL 1999 10:31AM Warren wrote:
Did you put the data field and the symbolic in an AMV group?
At 07 JUL 1999 11:34AM Mike wrote:
No I haven't, if you do that, the data will not display at all.
At 07 JUL 1999 02:21PM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Try adding to the end of the Xlate.
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 07 JUL 1999 02:36PM Warren wrote:
If Andrew's solution doesn't work, did you set the multivalue property in the prompt settings of the Window to 1?
At 07 JUL 1999 03:20PM K Gilfilen wrote:
I'd suggest you figure out how to make it work in an AMV group, because you get a lot of other useful MV variables created then, and besides, it is a multivalued type of data. Try doing that and using @MV instead of MV, and follow the other suggestion about using . You can probably make it work otherwise, but then you are building an application on a crooked foundation, if you'll pardon the analogy.
At 08 JUL 1999 04:46AM John Gunther wrote:
Here's a short tutorial on how MV symbolics work:
When a real MV field is evaluated, the result includes all values if @MV is null or 0, but only the @MV'th field if @MV has a positive numeric value. However, when evaluating an MV symbolic, it is up to the formula to emulate this action (this is a bug of such long standing that it long ago became a feature). The simplest way to do this, albeit not always the most efficient, is calculate the entire multivalued result and finish with @ans=@ans.
The cause of your problem goes a little further: @MV is set on entry to a formula by various system functions. In particular, XLATE always sets @MV=0, thus returning the entire multivalued field (another enshrined bug). In your case, the window display field is attempting to fill each line by setting @MV to 1, 2, etc. and evaluating the symbolic, but in each case XLATE is setting @MV=0, retrieving the 1 line address, and restoring @MV. Thus line 1 is returned for each line of the display field, unless you append to the XLATE line
I know others already gave you the fix, but this may help clarify what's happening.
At 08 JUL 1999 04:49AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:
Someone's up early…
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 09 JUL 1999 03:50PM Mike Daniel wrote:
Andrews action solved the problem perfectly.
Many thanks Andrew, I have do that same thing before a few months
ago but could not remember how I did it.
Thanks again everyone who tried to help..