{{tag>category:"OpenInsight 32-Bit" author:"Mike O'Neal" author:"John Bouley" author:"The Sprezzatura Group"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== mv fields and xlate (OpenInsight 32-Bit) ====
=== At 09 FEB 2005 03:42:03PM Mike O'Neal wrote: ===
 
 
<QUOTE>
Hi all - I have a saved list, sorted on a mv field, such as:



51380?1

51380?2

51380?3



The mv field contains record keys to another table, which I want to use in a symbolic field in an XLATE statement.  Even though the mv field shows only one key in an r/list or s/list statement (as expected), when I use the same field in an xlate it shows all keys.  Is there any way to find out which value I'm on before the I make the xlate call?



TIA,



Mike O.
</QUOTE>
----

=== At 09 FEB 2005 04:23PM John Bouley wrote:  ===

<QUOTE>Have you tried @mv?



John

</QUOTE>

----

=== At 10 FEB 2005 12:08AM Mike O'Neal wrote:  ===

<QUOTE>John, how can I do this?



Mike

</QUOTE>

----

=== At 10 FEB 2005 08:26AM The Sprezzatura Group wrote:  ===

<QUOTE>Depends on how you are making the calls.

In the symbolic though, you should be able to get the field names, and then check @MV and return only that field.



If you're doing the readnext yourself, then it's

READNEXT ID,MVPOS...





The Sprezzatura Group

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 10 FEB 2005 09:06AM Mike O'Neal wrote:  ===

<QUOTE>The call is from an s/list LIST statement with and active select list.  @ID returns only the key (51830), not the key + the value (51830?1, 51830?2, etc.)  If I knew the value I'd be home free (I think!), I just don't see it in any of the global variables.  Any way to find that out, other than by @ID?



Mike O.

</QUOTE>

----

=== At 10 FEB 2005 11:54AM John Bouley wrote:  ===

<QUOTE>Mike,



It would be easier if you posted the symbolic code.



How about this?

key={othertablekey}

Ans=Xlate(othertable,key,fieldnumber,"X")



HTH,

John

</QUOTE>

----

=== At 11 FEB 2005 03:10AM The Sprezzatura Group wrote:  ===

<QUOTE>No, there is not, but that's a good enhancement for the next version.



The Sprezzatura Group

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 11 FEB 2005 02:32PM Mike O'Neal wrote:  ===

<QUOTE>Hi John - 



I think the Sprezz folks answered my question on this, which is that unfortunately there is no way to pick up which @mv you're on if you've sorted on a mv field.



Mike

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=F921039DC5DCF35585256FA30071B6D9|View this thread on the Works forum...]]