- Using the TableAdd function
- Principle
- Code samples
- Using TableAddLine
- Principle
- Code samples
- Using the FileToMemoryTable function
- Principle
- Code example
How to populate a Table control programmatically?
Several methods can be used to populate a Table control programmatically: Using the TableAdd function Principle TableAdd is used to add a row to a Table control managed programmatically. To add the row, you must: - Declare a variable to prepare the row to add.
- Concatenate each column value in this variable. Each value is separated by a TAB character. The row to add must have the following format:
Row = <Value Column 1> + TAB + <Value Column 2> + TAB + ... + TAB + <Value Column N>
- Add the row with TableAdd.
Code samples - Adding a simple row:
sRow is string
sRow = Today() + TAB + TimeSys() + TAB + "my message..."
TableAdd(TABLE_messages, sRow)
- Adding the records from the Product file to a Table control:
sRow is string
// Clear the contents of the Table control
TableDeleteAll(TABLE_Products)
FOR EACH PRODUCT
sRow = Product.Reference + TAB + Product.ProdCap + TAB + Product.Price
TableAdd(TABLE_Products, sRow)
END
Info("There are " + TableCount(TABLE_Products) + " added products.")
Principle TableAddLine is used to add a row to a Table control managed programmatically. The only difference with the previous method (using TableAdd) is a syntax difference. Code samples - Adding a simple row:
// Add a simple row
TableAddLine(TABLE_messages, Today(), TimeSys(), "my message...")
- Adding the records from the Product file to a Table control:
// Add the PRODUCT file to a Table control
sRow is string
// Clear the contents of the Table control
TableDeleteAll(TABLE_Products)
FOR EACH PRODUCT
TableAddLine(TABLE_Products, Product.Reference, Product.ProdCap, Product.Price)
END
Info("There are " + TableCount(TABLE_Products) + " added products.")
- Adding the records from the Product file to a Table control (column by column):
<code WL>
sRow is string
nAddedRowNum is int
// Clear the contents of the Table control
TableDeleteAll(TABLE_Products)
FOR EACH PRODUCT
// Add an empty row
nAddedRowNum = TableAddLine(TABLE_Products)
// Modify the columns separately
TABLE_Products.Col_Ref[nAddedRowNum] = Product.Reference
TABLE_Products.Col_Cap[nAddedRowNum] = Product.ProdCap
TABLE_Products.Col_Price[nAddedRowNum] = Product.Price
END
Info("There are " + TableCount(TABLE_Products) + " added products.")
Using the FileToMemoryTable function Principle FileToMemoryTable populates a Table control managed programmatically from a data file (or from an SQL query) in a single operation (without using a loop). However, the structure of the Table control (format of columns and order of columns) must exactly correspond to the format of the file or SQL query: the item 1 of the file or SQL query will be associated with column 1, then the item 2 of the file or SQL query will be associated with column 2, etc. Code example
FileToMemoryTable(TABLE_PRODUCT, Product)
This page is also available for…
|
|
|
|