mibuso.com
Home› NAV/Navision Classic Client
Options

need help with calculated field

HuebiHuebi Member Posts: 7
edited 2004-12-06 in NAV/Navision Classic Client
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.

Comments

  • 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.
    Regards
    Peter
  • Options
    ArhontisArhontis Member Posts: 667
    Hi,

    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."
    Regards,
    Arhontis

    https://forum.mibuso.com/search
  • Options
    NaviTools.comNaviTools.com Member Posts: 88
    Hi uebi,

    Why two posts about the same thing :wink:

    http://www.mibuso.com/forum/viewtopic.php?t=4304

    At least link them.
    http://www.NaviTools.com
    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.