[Han]

Hi, I have been busy with other things recently. Which version of Rapid SCADA is needed?

[Han]

I’m sorry, my English is poor, and I don’t know if the grammar I described is correct. I use Google Translate.

[Han]

Hi,Mikhail
Thank you for your help all the time.
Sorry, I failed to describe my needs clearly before. I want to write the data (data1, data2, data3…) obtained by Modbus into the SQL table at a frequency of once a minute. The columns of the SQL table are arranged in accordance with the (writing time, data1, data2, data3… ).Retrieving data from Modbus has been successful. But I don’t know how to write SQL in the above arrangement.

[Han]

How to declare variables？

[Han]

2021-06-22 22:32:13 Establish a TCP connection with :1433

2021-06-22 22:32:13 Communication session with the Device 2 “SQL2008”, type: KpDbImport
Data request
Error executing query: scalar variable “@CnlNum” must be declared.
Data request
Error executing query: scalar variable “@CnlNum” must be declared.
Data request
Error executing query: scalar variable “@CnlNum” must be declared.
Data request

[Han]

Microsoft SQL Server，KpDbImport or ModDBExport;Could you provide the following example ?Thank U

[Han]

SQL1SQL2

[Han]

Sorry, I am a novice, can you provide the usage of @cmdVal and @cmdNum. I want to write the value read by modbus into SQL, for example, write the value of channel 101 of modbus into SQL?

• This reply was modified 2 years, 10 months ago by Han.

[Han]

Microsoft SQL Server,KpDbImport,thank you !

[Author]

Posts