Returns data from any SYSPRO table as an array.
SysproGetTableData([TableName], [Column List], [Number of Rows to Return], [Order Column])
SysproGetTableData([TableName], [Column List], [Number of Rows to Return], [Order Column], [Include Headers])
SysproGetTableData([TableName], [Column List], [Number of Rows to Return], [Order Column], [Condition Column], [Condition Text], [Condition Value], [Include Headers])
Where:
TableName is the SYSPRO table from which the data will be pulled.
Column List is a pipebar (|) delimited list of columns to return.
Number of Rows to Return is the number of rows to return. Use 0 (Zero) to return all matching rows.
Order Column is the column to use for ordering ascending. Leave blank for no ordering.
Include Headers is TRUE to include the header row, FALSE to exclude.
Condition Column is the name of the column the condition is to be applied.
Condition Text is the condition text. See table below.
Condition Value is the value to compare.
| Condition Text | Condition Value | Meaning |
|---|---|---|
| GT | 280 | Condition Column will be compared to a value greater than 280 |
| GE | 280 | Condition Column will be compared to a value greater than or equal to 280 |
| LT | 280 | Condition Column will be compared to a value less than 280 |
| LE | 280 | Condition Column will be compared to a value less than or equal to 280 |
| EQ | 280 | Condition Column will be compared to a value equal to 280 |
| NE | 280 | Condition Column will be compared to a value not equal to 280 |
| LIKE | * | Condition Column will be compared to * (returns all records) |
Rule | Meaning |
|---|---|
| SysproGetTableData("Customers","Name|Contact",5,"Contact","Name","Like","*",TRUE) | Returns the records from the Name and Contact columns of the Customers table, where the Name column matches * (all records). Includes Headers. |
Visit the SYSPRO PowerPack page to learn more.