986
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Error codes related to database access instructions
The following table lists the error codes that could be stored in the completion status of database access instructions.
Error
code
Error content Action
0103H CPU internal error Turn power off and turn it on again or reset the system and check
whether the instruction can be executed.
0104H Another database access instruction is being executed. Check that another database access instruction is not executed before
one database access instruction is completed.
0105H • The specified path is not a database folder.
• The database is broken.
Check whether the folder specified by the path contains a database file.
If not, correct the path properly.
0106H • A file in the database cannot be opened.
• A database built with a different firmware version is specified.
Create a new database using the DBIMPORT(P) instruction.
0107H An invalid drive number is specified by the database access instruction. Check whether the specified drive number is 2. If not, specify drive
number 2 correctly.
0108H Deletion of the database failed. Check that another function is not accessing the database and create a
new database using the DBIMPORT(P) instruction.
07D1H The specified table is not found in the database. Check that the database contains the specified table.
0940H An invalid character is included in the table name. Begin the table name with a non-numeric character and do not include
an invalid character.
0941H The table name is duplicated. Database table names are not case-sensitive. Check whether same
characters are used to set Unicode text file table names by
differentiating them with uppercase and lowercase characters.
0942H The specified table is not found in the database. Check that the database contains the specified table.
0945H The specified database is in use by another function. After the database operation by another function has been completed,
execute the instruction again.
0946H The specified table is in use by another function. After the table operation by another function has been completed,
execute the instruction again.
094AH The database name is not specified. Specify a correct database name.
094BH No database is stored in the specified folder. Check that the folder name is correct and that the folder contains a
database-related file.
094CH The field name contains an invalid character. Do not include any invalid character in the field name.
094DH The specified field name is duplicated. Check for duplicated field names in Unicode text files or instruction
arguments. If any, correct it to prevent duplication.
094EH A non-existent field is specified. Check that the specified field exists in the table.
0950H An invalid character is included in the index. Do not include any invalid character in the index.
0951H An attempt was made to set empty data (NULL value) in the main key
or in the field that has a NOT NULL constraint.
Confirm the table structure. Check whether the field permits NULL. If
not, set significant data.
0952H An attempt was made to add the same value to the field that has a
primary key constraint.
Check that the setting value of the record attempted to add to the field
that has a primary key constraint is not the same as the record already
registered.
0953H If overlapped data are set to the field where an index is set repeatedly,
the data for the index become large and the memory of the CPU
module cannot secure enough free space.
Change the table definition where the error is detected and re-build the
database.
0954H The setting value cannot be automatically converted to the format
appropriate for the data type.
Check that the format of the setting value meets the specifications.
0959H The data type that is checked during importing differs from the data
type defined in the table.
Check the Unicode text to verify that the setting value to be imported is
appropriate for the data type of the field.
095CH The data types of compared values are incorrect such as comparing
the sizes of character strings.
Correct the values to be compared.
095DH Converting the data type of the setting value specified in an argument
of the database access instruction failed and therefore the setting value
cannot be stored in the field.
Check that the setting value meets the data type specifications.
095EH An attempt was made to assign more than one index to one field. Check that an attempt has not been made to add an index to the field
where the primary key or external key is set. Check also that an
attempt has not been made to assign more than one index to one field.
095FH The index name is duplicated. Check that each index name is not duplicated.
096CH The setting value to be added to the field where the external key is
specified as a key constraint is not included in the setting values of the
reference.
Check the setting values of the reference.
To Next Page
Loading...
