4D v13
PV SET 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 SET CELL FIELD
| PV SET 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 SET CELL FIELD command links a field to cell area whose coordinates correspond to where column and row intersect.
table is the number of the table in which you want to link the current record to the cell. The displayed value is that of the field for the current record.
The cell is linked to field in a dynamic manner: any modification of the value is automatically reflected in the current record field and vice-versa.
It is possible to build an input form composed of 4D View cells: each of them allowing visualization and modification of associated fields using the PV SET CELL FIELD command. The record could be handled by the callback method or another form object, for a looped entry:
C_INTEGER($Table;$Field) `Associated fields reference
If(Form event=On Load)
PV GET CELL FIELD(Area;2;1;$Table;$Field) `Is a field linked to B1?
If($Table=0)&($Field=0)
PV SET CELL FIELD(Area;2;1;1;4) `B1 : [Clients]LastName
End if
PV GET CELL FIELD(Area;2;2;$Table;$Field) `Is a field linked to B2?
If($Table=0)&($Field=0)
PV SET CELL FIELD(Area;2;2;1;3) `B2 : [Clients]FirstName
End if
`Labels
PV SET CELL STRING VALUE(Area;1;1;"Last Name :")
PV SET CELL STRING VALUE(Area;1;2;"First Name :")
CREATE RECORD([Clients]) `New client entered
End if
Product: 4D
Theme: PV Cell value
Number:
15918
Created: 4D View 6.8
PV ADD DYNAMIC FIELDS
PV GET CELL FIELD
PV Get cell value type
PV SET CELL VARIABLE
