help version with multi value
- Gabriel_ACE
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 24
- Thank you received: 0
10 years 5 months ago #16733
by Gabriel_ACE
help version with multi value was created by Gabriel_ACE
hello (again)
I create this table
$INCLUDE T24.BP I_COMMON
$INCLUDE T24.BP I_EQUATE
$INCLUDE T24.BP I_DataTypes
$INCLUDE T24.BP I_Table
MAT F = '' ; MAT N = '' ; MAT T = ''
MAT CHECKFILE = '' ; MAT CONCATFILE = ''
*
ID.F = '@COD.JURI' ; ID.N = '3' ; ID.T = "A"
*
neighbour = ''
fieldName = 'XX-ENTE'
fieldLength = '5'
fieldType = 'A'
neighbour = ''
CALL Table.addFieldDefinition(fieldName, fieldLength, fieldType, neighbour)
fieldName = 'XX-SISCE.SEC.D'
fieldLength = '4'
fieldType = ''
neighbour = ''
CALL Table.addFieldDefinition(fieldName, fieldLength, fieldType, neighbour)
NOW
as I define the VERSION that allows me to load data into a multi value field?
I create this table
$INCLUDE T24.BP I_COMMON
$INCLUDE T24.BP I_EQUATE
$INCLUDE T24.BP I_DataTypes
$INCLUDE T24.BP I_Table
MAT F = '' ; MAT N = '' ; MAT T = ''
MAT CHECKFILE = '' ; MAT CONCATFILE = ''
*
ID.F = '@COD.JURI' ; ID.N = '3' ; ID.T = "A"
*
neighbour = ''
fieldName = 'XX-ENTE'
fieldLength = '5'
fieldType = 'A'
neighbour = ''
CALL Table.addFieldDefinition(fieldName, fieldLength, fieldType, neighbour)
fieldName = 'XX-SISCE.SEC.D'
fieldLength = '4'
fieldType = ''
neighbour = ''
CALL Table.addFieldDefinition(fieldName, fieldLength, fieldType, neighbour)
NOW
as I define the VERSION that allows me to load data into a multi value field?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
10 years 5 months ago #16736
by jpb
Replied by jpb on topic help version with multi value
For defining associated MV you should use
XX<ENTE
XX>SISCE.SEC.D
If the definition is correct you will be able to enter data with plain application, no need to define a VERSION.
From doc:
Multi-valued fields
Any field (except the record id) can be multi-valued. They can be individual multi-valued fields; multi-valued in association with a language code, or part of a group of fields whose multi-values are always in association with each other. Individual multi-valued fields are defined by setting their 'F' table element to 'XX.' followed by the field name, e.g.
F(Z) = ‘XX.NARRATIVE’
Language associated multi-values allow several translations of the value of the field to be held on the record, the appropriate multi-value being used according to the language code of the user. These are defined by setting the 'F' table element to 'XX.LL' followed by the field name, e.g.
F(Z) = ‘XX.LL.DESCRIPTION’
Multi Value Associated Fields
Associated groups of multi-values are defined by setting the third character of the 'F' table to '<' for the first field of the association, '-' for intermediate fields and '>' for the last associated field.
= 'XX<CURRENCY'
= 'XX-CHARGE.RATE'
= 'XX-LOWER.LIMIT'
= 'XX>UPPER.LIMIT'
Sub valued fields
Any multi-valued field can be sub-valued. These can be defined individually or as associations on sub-values within each multi-value. Single valued fields or record ids cannot be sub-valued. Sub-values are defined in the same way as multi-values except characters 4 to 6 of the 'F' table elements are used instead of characters 1 to 3.
= 'XX<CURRENCY'
= 'XX-XX<CHARGE.RATE'
= 'XX-XX-LOWER.LIMIT'
= 'XX>XX>UPPER.LIMIT'
XX<ENTE
XX>SISCE.SEC.D
If the definition is correct you will be able to enter data with plain application, no need to define a VERSION.
From doc:
Multi-valued fields
Any field (except the record id) can be multi-valued. They can be individual multi-valued fields; multi-valued in association with a language code, or part of a group of fields whose multi-values are always in association with each other. Individual multi-valued fields are defined by setting their 'F' table element to 'XX.' followed by the field name, e.g.
F(Z) = ‘XX.NARRATIVE’
Language associated multi-values allow several translations of the value of the field to be held on the record, the appropriate multi-value being used according to the language code of the user. These are defined by setting the 'F' table element to 'XX.LL' followed by the field name, e.g.
F(Z) = ‘XX.LL.DESCRIPTION’
Multi Value Associated Fields
Associated groups of multi-values are defined by setting the third character of the 'F' table to '<' for the first field of the association, '-' for intermediate fields and '>' for the last associated field.
= 'XX<CURRENCY'
= 'XX-CHARGE.RATE'
= 'XX-LOWER.LIMIT'
= 'XX>UPPER.LIMIT'
Sub valued fields
Any multi-valued field can be sub-valued. These can be defined individually or as associations on sub-values within each multi-value. Single valued fields or record ids cannot be sub-valued. Sub-values are defined in the same way as multi-values except characters 4 to 6 of the 'F' table elements are used instead of characters 1 to 3.
= 'XX<CURRENCY'
= 'XX-XX<CHARGE.RATE'
= 'XX-XX-LOWER.LIMIT'
= 'XX>XX>UPPER.LIMIT'
The following user(s) said Thank You: Gabriel_ACE
Please Log in or Create an account to join the conversation.
Time to create page: 0.035 seconds