version 2003
QR Find column (area; expression) Longint
Parameter | Type | Description | |
area | Longint | Reference of the area | |
expression | String | Pointer | Column object | |
Function result | Longint | 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