access to formula value

SupportCommunity FPScript access to formula value

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #12714
    Anonym
    Gast

    I would like to access and to extract the formula value into a data set in order to make other calcultation and work with VB.

    How can I do it ?

    regards,

    #8377
    Anonym
    Gast

    I would like to access and to extract the formula value into a data set in order to make other calcultation and work with VB.

    How can I do it ?

    regards,

    #9167
    Bernhard KantzBernhard Kantz
    Moderator

    It’s possible to evaluate a FPScript formula. In VBA you can use the Evaluate method.

    
    Dim oFml as Formula
    Set oFml = ThisDatabase.RootFolder.Object("Formula", fpObjectTypeFormula)
    oFml.Evaluate
    
    Dim oDataset as Dataset
    Set oDataset = ThisDatabase.RootFolder.Object("Formula", fpObjectTypeDataSet)
    Dim vtValue
    vtValue = oDataset.value
    

    support@weisang.com

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.