958
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
■Insertion data
*1 "1" to "16" for a programmable controller CPU with firmware version earlier than "28"
The following figure shows the format of (s4). Set the value corresponding to each field set in (s3).
• The data size of each value follows the size of the data type of each field.
Operand: (s4)
Device Item Description Setting range Set by
+0 Number of records Specify the number of records to be added.
The number of records to be added is a value which satisfies the following formula:
*1
Number of records (m) (32768/Data size per record)
1 to m
*1
User
+1 Size Specify the size of one record. Depends on the
data type
User
+2 to + Value to be added Specify the data for the number of fields specified by (s3) for the number of records
(m) specified by (s4)+0.
Depends on the
data type
User
Data type of field Data size (unit: word)
BOOL 1
WORD 1
DWORD 2
INT 1
DINT 2
REAL 2
LREAL 4
STRING • Even number of characters: (Number of characters2)+1
• Odd number of characters: Rounding up the number of characters2
[Example]
STRING: 32: (322)+1=17
STRING: 15: (152)=7.5 rounding up8
WSTRING Number of characters+1
[Example]
WSTRING: 32: (32)+1=33
1
n
1
n
b15 b0
(s4)+1
(s4)+2
(s4)+
(s4)
n
1
n
1
Set the number of records, 'm'.
Set the data size per record.
A value set in the 1st field
A value set in the 'n'th field
A value set in the 1st field
A value set in the 'n'th field
Data for one
record
Data for 'm'
records