Storing the result of a formula with Database Import Driver

[David01]

Hello,

I am using a database to store data from Rapid Scada. I want to save the value of an input into a table.

In order to do this, I have created an output with a formula that references the value I want to save. It has the same command number as that the one I defined in the driver. The problem is that, when I send a command, the value saved is whatever value is written in the command, instead of the result of the formula.

The SQL code I am using for the command is:

INSERT INTO data (Counter1) VALUES (@cmdVal);

So, my question is: How can I write the result of a formula in a MySQL database?

• This topic was modified 4 years, 12 months ago by Mikhail.

[Mikhail]

Hello,

Do you use Database Import Driver?

[Mikhail]

Please provide screenshots that illustrate your settings and system behavior.

[David01]

Yes. I am using Database Import Driver.

I managed to make it work on my own. I think I had done something wrong with the configuration. I am sorry for the trouble.

Now I have another question: Is there a way to store data in a database automatically over time , without a prompt?

If I understood this correctly, the only way to save data is by sending a command, isn’t it?

[David01]

Also, is there a way to store multiple data in a single sql table with a single command?

The documentation references the cmdVal variable, but that only sends the value of the current command. So, what if I need to store several variables?

For example, table1 has two columns: variable1 and variable2. I can use an SQL query like this:

INSERT INTO table1(variable1, variable2) VALUES (@cmdVal, null)

I can only pass the data for variable1, that’s why I am forced to pass a null value to variable2. Do I need to create an aditional command to write variable2 on the table?

[Mikhail]

Is there a way to store data in a database automatically over time , without a prompt?

You should use DB Export Module of SCADA-Server instead of DB Import driver.

If I understood this correctly, the only way to save data is by sending a command, isn’t it?

It’s true for DB Import Driver.

• This reply was modified 4 years, 11 months ago by Mikhail.

[David01]

Thank you. I will look into it.

[Author]

Posts