Skip navigation
MyWeisang
MyWeisang

Account settings
MyWeisang
Logout

Topic

access to formula value

Home page › Community › FPScript › access to formula value

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • 14.04.2011 at 11:44 #33445
    Anonym
    Guest

    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,

    14.04.2011 at 11:44 #33447
    Anonym
    Guest

    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,

    20.04.2011 at 13:38 #33446
    Bernhard Kantz
    Participant

    It’s possible to evaluate a FPScript formula. In VBA you can use the [b]Evaluate[/b] method.
    [code]
    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
    [/code]
    support@weisang.com

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.