4D v13.4

QR Find column

Home

 
4D v13.4
QR Find column

QR Find column 


 

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

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 

Product: 4D
Theme: Quick Report
Number: 776

This command modifies the Error system variable

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D 2003