4D v13

PV SET CELL FIELD

Home

 
4D View v13
PV SET CELL FIELD

PV SET CELL FIELD 


 

PV SET CELL FIELD ( area ; column ; row ; numTable ; numField ) 
Parameter Type   Description
area  Longint in 4D View area
column  Longint in Cell column number
row  Longint in Cell row number
numTable  Integer in Table number
numField  Integer in 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.

Example  

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

 
PROPERTIES 

Product: 4D
Theme: PV Cell value
Number: 15918

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D View 6.8

 
SEE ALSO 

PV ADD DYNAMIC FIELDS
PV GET CELL FIELD
PV Get cell value type
PV SET CELL VARIABLE