Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
  • Page:
  • 1

TOPIC: Trigger to MySQL

Trigger to MySQL 3 years 1 month ago #10938

  • marc
  • marc's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 710
  • Thank you received: 70
  • Karma: 24
Hi Claes,

I am starting to use a hand-held while doing regular maintenance in our production environment.
What I wish, is to trigger plant values in a MySQL database (localhost/button) and not by using the standard ScanTime from a SevHistMonitor.

In my plant I have a SevHist configured.
In the option as "Event", I am trying to trigger values in a (working) MySQL database.

Tried all kinds of combinations.
Without success.

Any idea what can be wrong?

/Marc
Please, use the Wiki if you succeeded your project or solved your problem. Share your work, so we can learn from each other.
The administrator has disabled public write access.

Trigger to MySQL 3 years 1 month ago #10939

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3176
  • Thank you received: 501
  • Karma: 133
Hi Marc,

I tried this

Attribute H1-Av4.ActualValue
ThreadObject Nodes-Test57-Servers-SevHistMonotor-1s
StorageTime 1 0:0:0
Options 34 (HighTimeResolution and Event)

When I set Trigger the value is stored.

You can check in the 'items' table in mysql that the correct setting are stored there.

/Claes
The administrator has disabled public write access.
The following user(s) said Thank You: marc

Trigger to MySQL 3 years 1 month ago #10940

  • marc
  • marc's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 710
  • Thank you received: 70
  • Karma: 24
Hi Claes,

Unbelievable.
And again you hit directly the nail.
In the 'items' table were wrong settings stored.
Thanks.

/Marc
Please, use the Wiki if you succeeded your project or solved your problem. Share your work, so we can learn from each other.
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 8.231 seconds