4D Doc Center : QR Find column

Home

4D v14.3

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

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.

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