Forum FlexPro – Discuss your topic!

access to formula value

Accueil > Community > FPScript > access to formula value

  • This topic has 2 replies, 2 voices, and was last updated 13 years ago by Anonymous.
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.