Value Tables

clear—Deletes the contents of the value table. The individual cells are overwritten with KWE (no value).

clearCell—Deletes the contents of a cell in one of the value tables. The contents of the cell are overwritten with KWE. A query with getCellType after clearCell returns variant:cellType:empty.

copyFrom—Copies the contents of the passed value table into the target table. The target table is dimensioned the same as the parameter table. A subsequent change to the dimension or value in one table has no effect on the dimension or values in the other table. Use the = operator to copy the content from a value table to another value table.

getCellType—Determines the data type of the specified cell.

getColumnLabel—Reads a column label from a value table. If the column label is not set, an empty string is stored in the text variable. If the label text is longer than the text that can be stored in the text variable, the label is truncated. The index starts at 0.

getPageLabel—Reads a page label from a value table. If the page label is not set, an empty string is stored in the text variable. If the label text is longer than the text that can be stored in the text variable, the label is truncated. The index starts at 0.

getRowLabel—Reads a row label from a value table. If the row label is not set, an empty string is stored in the text variable. If the label text is longer than the text that can be stored in the text variable, the label is truncated. The index starts at 0.

resize—Enlarges, reduces, or changes the dimensions of a value table. If an error occurs, the status is less than 0. If columns are used as parameters only, then a 1 x n value table is created. If the value table is enlarged, content is filled with KWE. If the value table is reduced, the value table is truncated.

setColumnLabel—Writes the value of the label variable to the column specified by the columnIndex variable. If an error occurs, the status is less than 0. The label is retained when the value table is redimensioned. The index starts at 0.

setPageLabel—Writes the value of the label variable to the page specified by the variable pageIndex. If an error occurs, the status is less than 0. The label is retained when the value table is redimensioned. The index starts at 0.

setRowLabel—Writes the value of the label variable to the row specified by the variable. If an error occurs, the status is less than 0. The label is retained when the value table is redimensioned. The index starts at 0.

fromCSV—Transfers the contents of a CSV file into a field. The dimensions of the field adjust to the dimensions of the file. If you do not specify a delimiter, the default is ;. If you do not specify labels, the default is 0. If an error occurred while reading the data, the status is less than 0.

toCSV—Writes the contents of the value table to a CSV file. The default is ; if you do not specify the separator. If labels are not present but are to be written, " is inserted. If labels are not specified, the default is 0. If an error occurred while writing the data, the value status of the variable is less than 0. The attempt evaluates the language setting of the PFR configuration. The attempt uses , or . as the decimal separator.

program
    variant[2,2] table
    table:clear()    // after execution the content is [KWE,KWE;KWE,KWE]
endprogram

program
    variant[2,2] table
    table:clearCell(0,0)
endprogram

program
    variant[2,2] target
    variant[3] source[1,2,3]
    target:copyFrom(source)
endprogram

program
    section globals
        variant[] table
    end section
    int32 row index
    for rowIndex = 0,rowIndex<tab:rows -1
        switch table:getCellType(rowIndex, 0)
            case variant:ce11Type:real64
                sys:loginfo(sys:ui,"element is integer")
            case variant:ce11Type:int32
                sys:loginfo( sys:ui,"element is float") case variant:cellType:text
                sys:loginfo(sys:ui,"value is text")
        end switch
    endfor
endprogram

program
    int32 columnIndex = 0
    text columnsText(10)
    variant[2,2] table
    columnText = table:getColumnLabel(columnIndex)
endprogram

program
    int32 pageIndex = 1
    text pagesText(10)
    variant[2,2,2] table
    pageText = table:getPageLabel(pageIndex)
endprogram

program
    int32 rowIndex = 1
    text linesText(10)
    variant[2,2] table
    rowText = table:getRowLabel(rowIndex)
endprogram

program
    text pagesText(10)
    int32 status
    variant[2,2] table = (1,2;3,4]
    status = table:resize(3)    //the result is a 1 x 3 field with the content [1,2,0]
    if status < 0 then
        sys:logError(sys:ui,"Error %d while increasing array", status)
    endif
endprogram

program
    int32 columnIndex = 1
    text columnsText(20) = "Label Column 2"
    variant[2,2] table
    table:setColumnLabel(columnIndex,columnText)
endprogram

program
    int32 pageIndex = 1
    text pagesText(20) = "Label Page 2"
    variant[2,2,2] table
    table:setPageLabel(pageIndex,pageText)
endprogram

program
    int32 rowIndex = 1
    text linesText(20) = "Label Line 2"
    variant[2,2] table
    table:setRowLabel(rowIndex,rowText)
endprogram

program
    int32 status int32[2,2] array
    status = array:fromCSV("Field.csv",";") if status < 0 then   
        sys:logError(sys:ui,"Error %d writing CSV file", status)
    endif
endprogram

program
    section globals
        variant[] table
    end section 
    int32 status
    status = table:toCSV("Field.csv",";") 
    if status < 0 then    
        sys:logError(sys:ui,"Error %d writing CSV file", status)
    endif
endprogram

Define PAscript value tables locally or globally.

The following pattern is used to define value tables:

variant[] variable_name

To declare a global value table in PAscript, enter the variant[] data type in a section globals code block. Then, enter the variable name.

program

  section globals
    variant[]  AKS_Parameter.WTB
  endsection

  ...

endprogram

The following pattern is used for defining local value tables:

variant[field dimensions] identifier

You can select one, two, or three dimensions for field dimensions.

variant [n]            identifier    // Value table with n elements
variant [n,m]        identifier    // Value table with n rows and m columns
variant [n,m,p]   identifier    // Value table with p pages, n rows and m columns

The cell content of the created value table is KWE.

program

        variant[2,3] table
        ...
endprogram

Access an element of a value table using access methods. Access methods assign the data type and have the relevant index for the column, row, and page as transfer parameters.

The = operator causes the table on the left to reference the table on the right.

The dimensions of the destination adapt to the dimensions of the source.

A subsequent change to the dimension or value in one of the tables changes the dimension or values in the other table.

program
  variant [2,3]    source
  variant [3,3,2]  target

  // causes redimensioning of the target
  target = source
endprogram