4D v13
PV ADD DYNAMIC ARRAYS
- 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 ADD DYNAMIC ARRAYS
| PV ADD DYNAMIC ARRAYS ( area ; array ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
4D View area | |||||
| array | String array |
|
Array containing names of array | |||||
The PV ADD DYNAMIC ARRAYS command adds in area a block of rows corresponding to the values of arrays whose names are passed using the array parameter, starting from the cell A1.
The arrays must all contain the same number of elements and are always presented vertically (as columns). The first array is displayed in the column A, the others in columns located to its right.
Note: If a dynamic field area was already inserted in the 4D View area using the PV ADD DYNAMIC FIELDS command, it is deleted and replaced by the dynamic arrays.
PV ADD DYNAMIC ARRAYS maintains a dynamic link with the arrays attached the dynamic portion of the area. As a result, modifications of values assigned in a 4D View area will be reflected within each array and vice versa. Deleting or adding elements in the 4D array will also be reflected within the area.
You cannot set several dynamic portions in the same 4D View area.
Notes:
- 4D array(s) and 4D View area must be defined in the same process.
- Dynamic data update is not available between the records displayed in the 4D forms and 4D View external windows. To reflect in a 4D View window a modification carried out in the 4D record, you need to redraw the window using the PV REDRAW command (modifications executed through 4D commands are automatically reflected into 4D View areas).
The following example get the names of contacts related to the current record of the clients table in an array, then displays the content in a 4D View area included in the input form of the client being modified.
Modifications executed by the user will be directly reflected in the 4D arrays, that we will have to next manage, for example, by updating the selection of recorded contacts.
ARRAY TEXT(NamesArray;0) `Contact names array
ARRAY TEXT(FirstnamesArray;0) `Contact first names array
ARRAY STRING(31;$ArrayArrays;2) `Arrays name array
$ArrayArrays{1}:="NamesArray" ` First dynamic column
$ArrayArrays{2}:="FirstnamesArray" ` Second dynamic column
RELATE MANY([Clients]Code) `Get linked contacts
SELECTION TO ARRAY([Contacts]ContactName;NamesArray;[Contacts]ContactFirstname;FirstnamesArray)
PV ADD DYNAMIC ARRAYS(Area;$ArrayArrays)
Product: 4D
Theme: PV Cell value
Number:
15902
Created: 4D View 6.8
PV ADD DYNAMIC FIELDS
PV CLEAR DYNAMIC COLUMNS
PV SET CELL VARIABLE
