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

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