DriveWorks Pro 16: SppSetColumnInTable [send feedback...]


Returns a table with all values set in a given column.


SppSetColumnInTable([Table Array],[Column],[New Value],[Exclude Header])


Table Array is a table array such as the data in a standard table or the result of the QueryDataValues function.

Column is the column on which to set the value. A number starting at 1 for the first column.

New Value is the new value for all rows of the given column.

Exclude Header is TRUE to not set the value in the first row (header), FALSE to set the value for all rows.


SppSetColumnInTable(DWLookupProductData,3,"Bought Out",TRUE)Will apply the value "Bought Out" for all values except the header in the given table.

Table of Contents