Get Data From Database Ms.Access Using Vijeo Citect Cicode Editor

HendyPratama

Member
Join Date
Apr 2018
Location
Indonesia
Posts
4
Hi guys, I want to get data from Microsoft access database using vijeo citect cicode editor..
however, I don't understand what the coding in cicode editor.
I have 1 table in ms.access and I give name for this table is Production
in the table, I have 2 column.. Time and Quantity.

on vijeo citect, I create a local variable tag..
Name for local variable tag is Quantity and type data is string.

I use the type data string because ms.access database only accept data with type data string.

to sending data to ms.access database I use coding like this

"INSERT IGNORE INTO Production" + "(Time, Quantity) VALUES ('" + TIME(1) + "' , '" + Quantity + "')";

the data can send to ms.access database.

now from access database I have data like this.

Time Quantity
11:10:00 900
11:10:02 850
11:10:04 800
11:10:06 750

the problem is I can't get the data from ms.access database to Vijeo Citect, I want to calculation data from column Quantity. in column Time, only data 11:10:00 and 11:10:02.

any suggestions can help me to solve this problem?
thank you before.
 

Similar Topics

please tell me how to create database in SQL and access historical data in RS View 32. as i know first i have to create ODBC conection for the SQL...
Replies
0
Views
1,847
You help me with instructions. I'm not into sports in particular Ifix intelution 3.5 like this: I do not know how to write code to automatically...
Replies
0
Views
2,382
Good Afternoon All. We have a 5 generator power station at site, with each generator controlled by an Allen Bradley SLC 5/02 PLC. These all...
Replies
5
Views
19,705
Hello. A semiconductor production machinery maker has inquired about a Windows application that be able to cyclically read data from an OPCUA...
Replies
9
Views
2,064
Hello, For my general information and knowledge, how is querying and storing data from a AB PLC (Compact or Control Logix) typically...
Replies
15
Views
7,285
Back
Top Bottom