FlexPro Forum – Discuss Your Topic!

access to formula value

Home > Community > FPScript > access to formula value

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • April 14, 2011 at 11:44 am #12714
    Anonymous
    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,

    April 14, 2011 at 11:44 am #8377
    Anonymous
    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,

    April 20, 2011 at 1:38 pm #9167
    Bernhard KantzBernhard Kantz
    Participant

    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

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