Omron NX701-1620 User Manual

3 Programming the DB Connection Function
3-19
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
3
3-4
Specifying the Table and
Applying the Mapping
3-4-3 Restrictions on DB Mapping
3-4-3 Restrictions on DB Mapping
The DB mapping has the following restrictions.
 Restrictions on Table’s Column Names:
When a character that cannot be specified for structure member names is used in a column
name of the table, you cannot create the mapping. You need to change the column name of the
table.
Example:
When a column name is P_Code
Table1
Name
LotNo
TotalCount
P_Code
...
...
...
...
...
...
...
...
Because you cannot use a text string
that starts with “P_” for a structure
member name, you cannot create the
mapping.
DB
Refer to Precautions for Correct Use: Restrictions on Table’s Column Names of 3-2-2
Specifications of Structure Data Type for DB Access for the characters that cannot be specified
for structure member names.
 Restrictions on Mapping to Multiple Tables:
You cannot map the members of a DB Map Variable to columns of different tables.
Example:
Structure data type definition used by a DB
Map Variable
▼Table1and2
Name
STRING[256]
LotNo
UINT
TotalCount
UINT
Pcode
UINT
Location
STRING[256]
Producer
STRING[256]
You cannot map structure members to
multiple tables.
Table1
Name
LotNo
TotalCount
PCode
...
...
...
...
...
...
...
...
DB
Table2
LotNo
Location
Producer
...
...
...
...
...
...
 Restrictions on Mapping to Multiple Tables:
You cannot map a DB Map Variable to two or more tables.
If you execute multiple DB_CreateMapping (Create DB Map) instructions so as to map a single
DB Map Variable to two or more tables, the mapping made by the last DB_CreateMapping
(Create DB Map) instruction takes effect.
Example:
Members of MapVar1 variable
are mapped with columns of
Table1.
Trigger
Create1
Connection1
‘Table1’
MapVar1
_DB_SQLTYPE_INSERT
DB_CreateMapping
Done
Busy
Error
ErrorID
Execute
DBConnection
TableName
MapVar
SQLType

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English