QR Find column
QR Find column ( area ; expression ) -> Function result
| Parameter | Type | Description | |
|---|---|---|---|
| area | Integer | → | Reference of the area |
| expression | Text, Pointer | → | Column object |
| Function result | Longint | ← | Number of the column |
This command is not thread-safe, it cannot be used in preemptive code.
Description
The QR Find column command returns the number of the first column whose contents match the expression passed in parameter.
expression can either be a string or a pointer.
QR Find column returns –1 if nothing has been found.
If you pass an invalid area number, the error -9850 will be generated.
Example
The following code retrieves the column number that holds the field [G.NQR Tests]Quarter and deletes that column:
$NumColumn:=QR Find column(MyArea;->[G.NQR Tests]Quarter)
or:
$NumColumn:=QR Find column(MyArea;"[G.NQR Tests]Quarter")
followed by:
If($NumColumn#-1)
QR DELETE COLUMN(MyArea;$NumColumn)
End if