4D v13
PV GET CELL FIELD
- 4D View Language
-
- PV Cell value
-
- PV Cell value, Introduction
- PV ADD DYNAMIC ARRAYS
- PV ADD DYNAMIC FIELDS
- PV ARRAY TO CELLS
- PV CELLS TO ARRAY
- PV CLEAR DYNAMIC COLUMNS
- PV FIELD TO CELLS
- PV FIELDS LIST TO CELLS
- PV Get cell boolean value
- PV GET CELL CONTROL
- PV GET CELL DATE TIME VALUE
- PV Get cell date value
- PV GET CELL FIELD
- PV Get cell formula
- PV Get cell num value
- PV Get cell picture value
- PV Get cell string value
- PV Get cell text value
- PV Get cell time value
- PV Get cell value type
- PV Get cell variable
- PV REPORT MANY
- PV REPORT ONE
- PV SET CELL BOOLEAN VALUE
- PV SET CELL CONTROL
- PV SET CELL DATE TIME VALUE
- PV SET CELL DATE VALUE
- PV SET CELL FIELD
- PV SET CELL FORMULA
- PV SET CELL NUM VALUE
- PV SET CELL PICTURE VALUE
- PV SET CELL STRING VALUE
- PV SET CELL TEXT VALUE
- PV SET CELL TIME VALUE
- PV SET CELL VARIABLE
- PV UPDATE DYNAMIC AREA
PV GET CELL FIELD
| PV GET CELL FIELD ( area ; column ; row ; numTable ; numField ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
4D View area | |||||
| column | Longint |
|
Cell column number | |||||
| row | Longint |
|
Cell row number | |||||
| numTable | Integer |
|
Table number | |||||
| numField | Integer |
|
Field number | |||||
The PV GET CELL FIELD command returns, in the table and field parameters, the number for tables and fields linked to the cell set by column and row.
Refer to the example for the PV SET CELL FIELD command.
The following example illustrates the use of the PV GET CELL FIELD command in a method enabling the sorting of dynamic columns when their header is clicked on. The area only contains dynamic columns. We begin by installing the EventMethod callback method that will be called in the event of a click in the area:
PV ON EVENT(area;pv on clicked;"EventMethod")This statement catches any clicks in the area. The EventMethod method will enable us to detect clicks in the column headers and to sort the data as a consequence.
`EventMethod Method
C_BOOLEAN($0)
C_LONGINT($1;$2;$3;$4;$5;$6)
C_INTEGER($tableNum;$fieldNum)
If($5=0) `If the click takes place in a header
$0:=True `Cancels the event
PV GET CELL FIELD(area;$4;1;$tableNum;$fieldNum) `Data to be sorted
ORDER BY(Table($tableNum)->;Field($tableNum;$fieldNum)->;>) `Sorting 4D data
End if `Linked values in the columns are automatically sorted
Product: 4D
Theme: PV Cell value
Number:
15913
Created: 4D View 6.8
PV Get cell value type
PV SET CELL FIELD
