mv fields and xlate (OpenInsight 32-Bit)
At 09 FEB 2005 03:42:03PM Mike O'Neal wrote:
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.
At 09 FEB 2005 04:23PM John Bouley wrote:
Have you tried @mv?
John
At 10 FEB 2005 12:08AM Mike O'Neal wrote:
John, how can I do this?
Mike
At 10 FEB 2005 08:26AM The Sprezzatura Group wrote:
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
World Leaders in all things RevSoft
At 10 FEB 2005 09:06AM Mike O'Neal wrote:
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.
At 10 FEB 2005 11:54AM John Bouley wrote:
Mike,
It would be easier if you posted the symbolic code.
How about this?
key={othertablekey}
Ans=Xlate(othertable,key,fieldnumber,"X")
HTH,
John
At 11 FEB 2005 03:10AM The Sprezzatura Group wrote:
No, there is not, but that's a good enhancement for the next version.
The Sprezzatura Group
World Leaders in all things RevSoft
At 11 FEB 2005 02:32PM Mike O'Neal wrote:
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