QueryAddcolumn()
Adds a new column of data to the exist query object, returning the column number
Usage
NUMERIC = QueryAddcolumn(
query,
column,
datatype,
valuearray
)
Argument | Summary |
---|---|
query | query |
column | column |
datatype | type of data; integer, decimal, varchar, bigint, double, binary, date, time, bit, timestamp |
valuearray | array of values [optional] |
Calling
Supports named-parameter calling allowing you to use the function like:
QueryAddcolumn( query=?, column=?, datatype=?, valuearray=? );
Supports passing parameters as a structure using ArgumentCollection:
QueryAddcolumn( ArgumentCollection={ query : ?, column : ?, datatype : ?, valuearray : ? } );
See Also
Csvread
Csvwrite
Datasourcecreate
Datasourcedelete
Datasourceinfo
Datasourceisvalid
Dbinfo
QueryAddcolumn
QueryAddrow
QueryColumnarray
QueryColumnlist
QueryDeletecolumn
QueryDeleterow
QueryEach
QueryIsempty
QueryNew
QueryOfqueryrun
QueryRenamecolumn
QueryRequestmetrics
QueryRowstruct
QueryRun
QuerySetcell
QuerySort
QueryToarray
Quotedvaluelist
ToHtml
Valuelist