Hi,

I'm currently in the process of setting up a SQL database that receives data from the PLC each time a specific event is triggered. I have managed to successfully establish a connection between my PLC and SQL and send fake values just to test it.

My next challenge is to figure out how to send live values using a stored procedure with inputs. Is there a way to directly link DB tags to the ‘execute' command, i.e. ‘execute myProcedure @input1="DBName".TemperatureSensor1' etc. when the ‘enable’ command goes to TRUE? I've tried multiple combinations but nothing has worked so far, so I'm guessing it's not that simple.

Apologies if this seems like a silly question, I'm fairly new to SQL and programming PLCs, and I couldn't find any useful info on how to do this.

Thanks in advance!

I followed the guide to set up the connection and it all works fine, I just cannot seem to find a way to send live values to the SQL database?

I'm using an ET 200SP [1512SP F-1 PN], firmware V2.9 and TIA Portal V19.

My SQL Command looks like this:

'execute SendSQLTest @nH2Pressure1=123.4, @ nH2Pressure2=567.8, @iHAValve=1'

I need to replace the fake numbers with actual data from the moment the SQL block is triggered to send data.

Came to the same conclusion, using S_CONV and CONCAT instructions seems to be the right way. Thanks!