QR Find column

QR Find column ( area ; expression ) -> Function result

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