fieldref.OPTIONCAPTION

CaponeCapone Member Posts: 125
Hi!
This problably have a simple solution but for the moment I can't figure out how to do it.

I have read several posts that I can get the caption from an option datatype using a combination of selectstr() and fieldref.Optioncaption.

But how do I get it if I'm not in the scope of the actual record where the field is?

Example:
From the vendor table I want to get the optioncaption from field "Value Posting" in table Default dimension.

I was hoping that could do it something like defaultdim."Value Posting".OPTIONCAPTION but apparently not :(
Hello IT, have you tried to turn it off and on?
Have you checked the cables?
Have you released the filters?

http://www.navfreak.com

Answers

  • einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    What do you want to do? If you just want to display the value of field "Value Posting" of the Default Dimension of a certain Vendor you neither need FieldRef nor OPTIONCAPTION nor SELECTSTR.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • CaponeCapone Member Posts: 125
    Sorry, maybe I was a bit unclear....

    In table vendor I have this pseudo code:

    IF defaultDim."Value Posting" <> defaultDim."Value Posting"::"Code Mandatory" THEN
    error("Dimension %1 must have Value Posting = %2",.....);


    I want %2 to be the caption to "Value Posting"::"Code Mandatory"
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?

    http://www.navfreak.com
  • einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    DefaultDim.TESTFIELD("Value Posting",DefaultDim."Value Posting"::"Code Mandatory");
    
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • CaponeCapone Member Posts: 125
    Cheers!
    :D
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?

    http://www.navfreak.com
Sign In or Register to comment.