Database MySQL usage

[Artos9]

Hello,
I would like to ask about MySQL DB cooperation with Rapid SCADA.
I implemented communication and works OK, but Rapid SCADA pulls only first record of database.
Please explain how finally it should works.
My database collect data from system monthly, and better situation is when data will be pull as the last record.

[Mikhail]

Hello,
You should check log files of the export module
C:\SCADA\ScadaServer\Log\ModDBExport.log
C:\SCADA\ScadaServer\Log\ModDBExport.txt

Are there any errors?

Please explain how finally it should works.

When new data is read from a controller, it should be written to the DB.

[Mikhail]

My database collect data from system monthly, and better situation is when data will be pull as the last record.

You can change the SQL scripts in the module settings according to the requirements.

[Artos9]

Hi,
I don’t have these files.
Only exists:
ScadaServerSvc.log
ScadaServerSvc.txt

In these files no errors are presented.

• This reply was modified 3 years, 5 months ago by Artos9.

[Artos9]

You can change the SQL scripts in the module settings according to the requirements.

Could you write more information’s?

[Mikhail]

Please make screenshots of your settings.

[Artos9]

Hi, I correct SQL request from SELECT * FROM Table to SELECT * FROM Table ORDER BY ID DESC LIMIT 1. Now is such better.

Thank you.

[Artos9]

Hello,
I would like to ask about Database data size import. I have seen that max size on text format is 8 char’s. Is something wrong with my settings?

Thank you.

https://imgur.com/9nlHqUk

[Mikhail]

Hello,
An input channel can store only 8 Latin characters, because channel value size is 8 bytes. SCADA mostly works with numbers than strings.

[Author]

Posts