Grass Valley K2 TX/MAM Database Protocol Manual v.2.2 - Manual (Page 4)

TX/MAM Database Protocol Manual - document version: 2.2 – Page 4
4.
Defines
The following defines are used within the library:
Name Value Description
Maximum values
MAX_IDS 1024 The maximum number of rows that
can be retrieved from the database in
one call.
SMALL_BLOB 1024 The size for a small text blob
database field.
Logical Search operators
LOP_AND “AND” This criterion will use the
'AND' operator with the next
criterion.
LOP_OR “OR” This criterion will use the 'OR'
operator with the next
criterion.
Criterion types
COP_GET_ALL “GET_ALL” Get all records from a table.
COP_EQUALS “EQUALS” Get all records where the
provided value equals the field
value.
COP_CONTAINING “CONTAINING” Get all records where the
provided value is part of the
field value. Can only be used
with string or text blob fields.
COP_GREATER_THAN “GREATER_THAN” Get all records where the field
value is greater than the
provided value; usually
applied for integer or int64
fields.
COP_SMALLER_THAN “SMALLER_THAN” Get all records where the field
value is smaller than the
provided value; usually
applied for integer or int64
fields.
COP_GREATER_THAN_OR
_EQUALS “GREATER_THAN_OR_EQ
UALS
”
Get all records where the field
value is greater than or equals
the provided value; usually
applied for integer or int64
fields.
COP_SMALLER_THAN_OR
_EQUALS “SMALLER_THAN_OR_EQU
ALS
”
Get all records where the field
value is smaller than or equals
the provided value; usually
applied for integer or int64
fields.
COP_ORDER_BY “ORDER_BY” Order the results by the
indicated field.
CRIT_ORDER_ASCENDING “ASCENDING“ Use the ascending sort order.