DriveWorks Pro 15: SppAddNumberColumn [send feedback...]

SppAddNumberColumn

Returns a table based on an existing table with a new first column added with an incrementing number and a specified column heading

Syntax

SppAddNumberColumn([Table Array],[Number Column Header Text],[IncludeLeadingZeros]) As Object

Where:

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

Number Column Header Text is the text to use as the new heading.

IncludeLeadingZeros is TRUE to include leading zeros, FALSE to exclude.

Examples

RuleMeaning
SppAddNumberColumn(DwLookupCustomers,"Reference",TRUE)Will return the table Customers with an additional column named Reference added to the start of the table.

Table of Contents