access to formula value

[Anonym]

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,

[Anonym]

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,

[Bernhard Kantz]

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