13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
249
13
*1 Rename the ID field.
1.
Start Microsoft Access and select "Blank database".
2.
Add the following fields.
Field name
Data type
Data type for when the data is exported to
the database of the CPU module
proID
AutoNumber type: Long integer
INT
Enduser
Numeric type: Long integer
INT
TargetX
Numeric type: Single-precision floating point type
REAL
TargetY
Numeric type: Single-precision floating point type
REAL
TargetZ
Numeric type: Single-precision floating point type
REAL
3.
Name the table "RecipeTable" and save it. After saving,
close the table.
4.
Right-click on RecipeTable, and select [Export]
[ODBC Database].
5.
When the window to specify the export destination is
displayed, click the [OK] button.
6.
On the window for selecting the data source, click the
[Machine Data Source] tab and select the data source of
the CPU module.
• When the default user is not set to the ODBC data source, input the user
name and password.
• When no data source of the CPU module is displayed in the window, add a
database of the CPU module to the ODBC data source. (
Summary of Contents for MELSEC iQ-R-R00CPU
Page 2: ......
Page 151: ...9 MONITOR FUNCTION 9 1 Real Time Monitor Function 149 9 MEMO ...
Page 323: ...18 SEQUENCE SCAN SYNCHRONIZATION SAMPLING FUNCTION 321 18 MEMO ...
Page 330: ...328 20 ROUTING SETTING 20 3 Precautions MEMO ...
Page 423: ...26 BASIC CONCEPT 26 8 State Transition of the Redundant System 421 26 MEMO ...
Page 1014: ...1012 APPX Appendix 15 Added and Enhanced Functions MEMO ...
Page 1027: ......