QueryRecordCount

Returns the absolute value of a number

Method Signature

QueryRecordCount(query=[query])

Arguments

Argument	Type	Required	Description	Default
query	query	true

Examples

Get the number of rows in a query

q = queryNew( "name", "varchar", [ [ "Alice" ], [ "Bob" ], [ "Carol" ] ] );
writeOutput( q.recordCount() );

Result: 3

Using the global function form

q = queryNew( "id,value", "integer,varchar", [ [ 1, "a" ], [ 2, "b" ] ] );
writeOutput( queryRecordCount( q ) );

Result: 2

Related

• QueryAddColumn
• QueryAddRow
• QueryAppend
• QueryClear
• QueryColumnArray
• QueryColumnCount
• QueryColumnData
• QueryColumnExists
• QueryColumnList
• QueryCurrentRow
• QueryDeleteColumn
• QueryDeleteRow
• QueryEach
• QueryEvery
• QueryFilter
• QueryGetCell
• QueryGetResult
• QueryInsertAt
• QueryKeyExists
• QueryMap
• QueryNew
• QueryNone
• QueryPrepend
• QueryReduce
• QueryRegisterFunction
• QueryReverse
• QueryRowData
• QueryRowSwap
• QuerySetCell
• QuerySetRow
• QuerySlice
• QuerySome
• QuerySort