[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Multivalue Xlate Problem (AREV Specific) ====
=== At 07 JUL 1999 09:44:38AM Mike Daniel rendermegone@earthlink.net wrote: ===
{{tag>"AREV Specific"}}
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
[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== 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
[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== 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..
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=C9185A6F255DAACA852567A7004B7F8A|View this thread on the forum...]]