Most record functions that operate on fields, take a field number as a parameter to indicate which field to operate on. ctdbGetFieldNumberByName() takes the field name and return its number.
If the field name passed to ctdbGetFieldNumberByName() is invalid, the function returns -1 (negative one).
/* update USERID field */
NINT fieldnbr = ctdbGetFieldNumberByName(hRecord, "USERID");
if (fieldnbr >= 0)
ctdbSetFieldAsString(hRecord, fieldnbr, "123456");
else
printf("Invalid field name\n");
The following operators are allowed in filters and conditional expressions.
Mathematical Operators
+ |
Adds two operands |
- |
Subtracts two operands or negates an operand (e.g., -5) |
* |
Multiplication |
/ |
Division |
% |
Modulus |
Relational Operators
== |
Equal to |
!= |
Not equal to |
< |
Less than |
<= |
Less or equal to |
> |
Greater than |
>= |
Greater than or equal to |
Logical Operators
&& |
And |
|| |
Or |
! |
Not |
Binary Operators
& |
And |
| |
Or |
~ |
Not |
^ |
Xor |
NULL Operators
IS NULL |
IS NOT NULL |