988
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
1000H The Unicode text file specified for importing does not exist. Check whether the file indicated by the folder path is a Unicode text file.
If not, specify a correct folder path.
1002H There is no identification number that can be allocated. A maximum of four databases can be opened. Adjust the number of
databases that will be opened to 4.
1003H The identification number of a database which is not open is specified. Use the DBOPEN(P) instruction to open the database in advance and
obtain an identification number.
1004H The identification number specified by the instruction is out of range. Specify the identification number obtained by the DBOPEN(P)
instruction.
1007H The number of fields to be specified by the instruction is not specified. Set 1 or greater for the number of fields in the argument.
1008H • The number of fields specified by the instruction is out of range.
• The field name specified by the instruction is out of range.
• Set 128 or less for the number of fields in the argument.
*1
• Specify a field name within the available range (up to 128th field) in
the argument.
1009H The number of records to be specified by the instruction is not
specified.
Set 1 or greater for the number of records in the argument.
100AH The number of records specified by the instruction is out of range. Set the number of records within the range in the argument.
100CH The Unicode text table or set-value delimitation does not follow the
format.
Check that the delimiters in the table or set-value delimitations follow
the format.
100DH An error occurred in the database. Turn power off and turn it on again or reset the system and check
whether the same symptom recurs.
100EH The condition number specified by the instruction is out of range. Check that the condition number range is correct.
100FH When two conditions are specified by the instruction, the logical
operator setting value is 0.
Check that the logical operator setting value in the argument is 1 or 2.
1010H The maximum number of databases that can be transacted is
exceeded.
Check that a transaction is not executed for two or more databases or
that another transaction is not executed while one transaction is
already running.
1011H The commit or rollback instruction is executed without starting a
transaction.
Check that the commit or rollback instruction is not executed while no
transaction is running.
1012H The value of the size per record used for adding or update is not
appropriate.
Check that the data size of each field matches the size of the data to be
added or updated.
1013H A data type which is not supported is specified. Check the data type of the Unicode text.
1014H • Another database is opened during execution of the transaction.
• The DBEXPORT(P) instruction is executed during transaction.
• Do not open a database newly during execution of the transaction.
• Execute the DBEXPORT(P) instruction after the transaction is
completed.
1015H A transaction is executed for the multiple databases that were already
open.
Close the databases that are not targeted for a transaction.
101BH The first condition is not set in the relevant argument of each
instruction.
Check that the field size set as the first condition in the argument is
other than 0 or whether the field name is null.
101CH The data size of a field is not included in multiple condition settings. Check that the data size of the field specified by the condition is 0.
101DH A field name is not included in multiple condition settings. Check that the field name specified by the condition is not null.
101EH The value of the inter-condition operator is out of range. Check that the value of the inter-condition operator is correct.
101FH The value of the inter-condition operator in the second condition setting
is out of range.
Check that a value other than 0 is not set in the logical operator setting
value of the second condition.
1020H The setting value is not within the range specified for the data type. Check that the setting value is within the range.
1021H An attempt was made to open a database which was already open. Check that the path corresponding to (s) of the DBOPEN(P) instruction
is not specified more than once.
1022H The DBIMPORT(P) instruction was executed while the database was
already open.
Close the database that is already open, and execute the
DBIMPORT(P) instruction.
1023H A table number outside the range is specified. Check that the table number is within the range.
102EH The field size specified in the conditions is out of range. Check that the field size in the conditions is within the range.
1030H The output size exceeds the setting value. Adjust the output size.
1031H The number of outputs exceeds the setting value. Adjust the number of outputs.
1032H Since the SD memory card was removed while opening the database
with the DBOPEN(P) instruction or executing a database access
instruction, the database access instruction cannot be executed or the
CPU module database access (from external device) function cannot
be executed from an external device.
Power off and on the CPU module or reset it.
1040H The total size of records to be added exceeds the limit. Adjust the total size of records to be added.
Error
code
Error content Action