CalculateColumns exemple

SupportCommunity Automation and VBA CalculateColumns exemple

Ansicht von 5 Beiträgen - 1 bis 5 (von insgesamt 5)
  • Autor
    Beiträge
  • #12421

    Hi, could you give me a proper exemple of how to use the CalculateColumns function for a dataset ?

    I got S as a dataset
    I want to add an offset to all y-data of that dataset.. I tried that, based on the helpfile, but it didn’t work…

    Formule (as string) = "x + " & offset
    S.CalculateColumns Formule, fpDataComponentY

    Also, I want to select just a small part of my entire dataset. I tried that code :

    Formule = x[[StartTime, EndTime]]
    S.CalculateColumns Formule, fpDataComponentAll

    Both method are working fine in FScript… I tought CalculateColumns method was the same as FScript.

    #8102

    Hi, could you give me a proper exemple of how to use the CalculateColumns function for a dataset ?

    I got S as a dataset
    I want to add an offset to all y-data of that dataset.. I tried that, based on the helpfile, but it didn’t work…

    Formule (as string) = "x + " & offset
    S.CalculateColumns Formule, fpDataComponentY

    Also, I want to select just a small part of my entire dataset. I tried that code :

    Formule = x[[StartTime, EndTime]]
    S.CalculateColumns Formule, fpDataComponentAll

    Both method are working fine in FScript… I tought CalculateColumns method was the same as FScript.

    #8689
    Bernhard KantzBernhard Kantz
    Moderator

    Expression.CalculateColumns(Formula, RowFrom, RowTo)

    Expression is an expression which returns an object of type DataSet.

    Example (in the root folder exists the dataset ‘S’):
    [Code]
    Dim oDataset As DataSet
    Dim str As String
    str = “x + 5”
    Set oDataset = ThisDatabase.RootFolder.Object(“S”, fpObjectTypeDataSet)
    oDataset.CalculateColumns str, fpDataComponentY
    [/Code]

    support@weisang.com

    #8690

    This is exactly what I did! I tried again and it works only when the dataset “S” is in the rootfolder. If I select a dataset in another folder, I can’t make it work. I get the message : “Invalid procedure call or argument”
    Here is my code :

        Dim oDataset As DataSet
        Dim str As String
    
        Set oDataset = ActiveDatabase.ActiveFolder.Object("S", fpObjectTypeDataSet)
        str = oDataset.FullName 'Here I check if the correct dataset is selected
        str = "x + 5"
        oDataset.CalculateColumns str, fpDataComponentY

    This code work fine when S is in the rootfolder, but it doesn’t when S is in a folder (but I checked that the dataset is well selected)

    I’m confused…

    #8691
    Bernhard KantzBernhard Kantz
    Moderator

    Thanks for this information!
    That seems to be a bug in the automation interface.
    We’ll fix this bug in the next release.

    Support@weisang.com

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