QR Find column
QR Find column ( area ; expression ) : Integer
| Parameter | Type | Description | |
|---|---|---|---|
| area | Integer | → | Reference of the area |
| expression | Text, Pointer | → | Column object |
| Function result | Integer | ← | Number of the column |
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
Properties
| Command number | 776 |
| Thread safe | ✗ |
| Modifies variables | error |