Database MySQL usage

Forum Home Forums Development and Integration Database MySQL usage

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #7518
    AvatarArtos9
    Participant

    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.

    #7521
    MikhailMikhail
    Moderator

    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.

    #7522
    MikhailMikhail
    Moderator

    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.

    #7526
    AvatarArtos9
    Participant

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

    In these files no errors are presented.

    • This reply was modified 1 week, 4 days ago by AvatarArtos9.
    #7527
    AvatarArtos9
    Participant


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

    Could you write more information’s?

    #7534
    MikhailMikhail
    Moderator

    Please make screenshots of your settings.

    #7546
    AvatarArtos9
    Participant

    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.

Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.