need help with calculated field

HuebiHuebi Member Posts: 7
I want to show if a recordset contains a picture (Blob field) in another field, but as i am new to navision, i couldn't get the desired effect from the available functions in calculated fields.
Can anyody help?
Smile! It can always get worse.


  • Options
    pdjpdj Member Posts: 643
    I'm not sure I understand what you mean, but I guess you wish to make a flowfield that is of type lookup to a BLOB field?

    That is not possible, because BLOB fields are very related to flowfields (i.e. you need to do a calcfields before exporting it). And just as you can't make a flowfield based on a flowfield you can't base it on a BLOB either.

    Depending on how you wish to use it, you might be able to solve it by creating a function on the table instead. You can easily show the output of the function directly on a form, however you can't set a filter on it.
  • Options
    ArhontisArhontis Member Posts: 667

    Since BLOB fields are managed thru Import/Export and Clear, you can make another field boolean, editable-false and change its value in the onvalidate trigger of your BLOB by using the HASVALUE of the BLOB.

    "Keep it simple."
  • Options
    NaviTools.comNaviTools.com Member Posts: 88
    Hi uebi,

    Why two posts about the same thing :wink:


    At least link them.
    Documentation for Microsoft Navision
    E/R diagrams, Workflow diagrams, UML diagrams, process diagrams
  • Options
    HuebiHuebi Member Posts: 7
    :oops: sorry for the crosspost.
    Smile! It can always get worse.
Sign In or Register to comment.