COM13c. [3/5]Sending INT and Real from S7-1200 to an SQL Database [Programming Section]

[@rebinshw]

The king, absolutely amazing

[@electricalautomation]

Thanks!

[@WarriorTutoriales]

exelente informacion bro .

[@electricalautomation]

Thanks my friend

[@weihuang7228]

干货满满！赞一个！

[@electricalautomation]

多谢！欢迎！

[@rebinshw]

i am asking, is it logical to took all of these steps to just transfer 4 data to SQL, 😢

[@mustaphaboudrik5390]

Thank you very much

[@electricalautomation]

Thanks for your watching！ Welcome!

[@MahadiHasan-qi1cb]

Excellent Video Content! Simply loved it. I have a question, I was wondering whether there are any Programming block's similar to Microsoft SQL also available for MySQL.

[@electricalautomation]

I have not seen any example allowing Siemens S7-1500 directly talk to MySQL. Alternatively, you could use Ignition, or KEPServerEX other bridge software to link them together

[@georgekoutsoudakis2812]

Why do we need to create 2 parts A & B, How can we modify the example in order to receiving everything in one part?

[@electricalautomation]

thanks for your watching! "SqlConfig".command is the actual string to be used to send to SQL, String_Part_A is a static string, while String_Part_B includes the data with string/char format. The entire topic has three videos, please check out the information below the video. the 2:30 of this video kzbin.info/www/bejne/j2HFfXymo9qHh68 explained the idea to convert the four data and combining four strings together, it could probably answer your second question.

[@georgekoutsoudakis2812]

@@electricalautomation I saw the video, i am just saying (maybe) we can create another sql config.command like a matrix who can take 4 strings instead .

[@electricalautomation]

​@@georgekoutsoudakis2812 Of course, my friend. That is a good idea! Welcome to open discussion and share your test.

[@Rafallaser]

Thanks for the helpful video! I have questions. How do I send a string variable?

[@electricalautomation]

I think string works. Actually, if you review 8:30, all the data which are sent to SQL is 'String'.

[@Rafallaser]

@@electricalautomation Thank you again :) I used the sign $'

[@diogoaugusto4373]

Amazing

[@electricalautomation]

Thank you! Cheers!

[@sebastianszczerbula8368]

Great job, but i have a question, what when in SQL we have a column where we don't insert value, for example column ID are increment automaticaly, and what when we want insert to the next column date?

[@electricalautomation]

The "Insert" command shown in the video will increment the line in the SQL. You can add the ID or Date as the data in the column and send as string.

[@NaveenKumar-kx4zw]

@@electricalautomation NOT WORKING WHEN I SENDING DATE AS STRING IN DATE COLUMN OF SQL (datetime AS datatype) , data is not inserting in sql table

[@lehel121]

Hi, can you read data back from SQl?

[@electricalautomation]

Hi This example application program from Siemens doesn't have read request. But I slightly think it potentially can, because the Tabular Data Stream has been there, probably PLC can send the command like "SELECT * FROM...." the SQL Statement to request/retrieve the data from SQL

[@SunilYadav-nb9wp]

Sir , please make vedio for file open ,file read and write in twincat 3

[@electricalautomation]

Hello, Thanks for your comments. But, I didn't get a chance to implement File operation in Beckhoff PLC. It would not be short to do this test for me. If the test is urgent for your, you could go to browse the link infosys.beckhoff.com/english.php?content=../content/1033/tcplclibsystem/html/tcplclibsys_fileio_example.htm&id= There is an example file from the Beckhoff website. Good Luck!

[@SunilYadav-nb9wp]

@@electricalautomation thanks

[@SCADAExperts]

Please make new program for S7 1500 using new code from Siemens site.

[@electricalautomation]

Please find the download link below the video

[@ag7258]

Where I can get lsql_microsoft function block Please help me anyone

[@electricalautomation]

The link can be found under the video, support.industry.siemens.com/cs/document/109779336/connecting-a-s7-1200-s7-1500-to-a-sql-database-?dti=0&lc=en-WW

[@SCADAExperts]

Please make new program for S7 1500 using new code from Siemens site.

[@electricalautomation]

Please find the download link below the video