QueryAddrow()
Adds the specified the number of rows to the end of the query, or transposes a structure into a query, creating additional columns if needed to support the keys in the structure. Only simple fields of the structure will be mapped (no inner structures for example)
Usage
BOOLEAN = QueryAddrow(
query,
rows,
data
)
Argument | Summary |
---|---|
query | query |
rows | rows to add [optional] |
data | data can be either a structure, or an array of structures; ignored if 'rows' is present [optional] |
Calling
Supports named-parameter calling allowing you to use the function like:
QueryAddrow( query=?, rows=?, data=? );
Supports passing parameters as a structure using ArgumentCollection:
QueryAddrow( ArgumentCollection={ query : ?, rows : ?, data : ? } );
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