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 ruclips.net/video/Y0bLIpnuTQM/видео.html explained the idea to convert the four data and combining four strings together, it could probably answer your second question.
@@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 .
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.
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
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?
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
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
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!
![COM13b. [2/5]V11 Connecting a Siemens PLC(S7-1200/S7-1500) to an SQL Database [PLC Section]](http://i.ytimg.com/vi/2wpFREYnJPY/mqdefault.jpg)
![COM13b. [2/5]V11 Connecting a Siemens PLC(S7-1200/S7-1500) to an SQL Database [PLC Section]](/img/tr.png)
![COM13d. [4/5]V20 Connecting a Siemens PLC S7-1500 to an SQL Database [PLC Section]](http://i.ytimg.com/vi/jDf2kF2gDug/mqdefault.jpg)
![COM13a. [1/5]Connecting a Siemens PLC(S7-1200/S7-1500) to an SQL Database [SQL Section]](/img/1.gif)
The king, absolutely amazing
Thanks!
i am asking, is it logical to took all of these steps to just transfer 4 data to SQL, 😢
Why do we need to create 2 parts A & B, How can we modify the example in order to receiving everything in one part?
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 ruclips.net/video/Y0bLIpnuTQM/видео.html explained the idea to convert the four data and combining four strings together, it could probably answer your second question.
@@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 .
@@georgekoutsoudakis2812 Of course, my friend. That is a good idea! Welcome to open discussion and share your test.
exelente informacion bro .
Thanks my friend
Thanks for the helpful video!
I have questions.
How do I send a string variable?
I think string works. Actually, if you review 8:30, all the data which are sent to SQL is 'String'.
@@electricalautomation Thank you again :) I used the sign $'
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.
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
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?
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.
@@electricalautomation NOT WORKING WHEN I SENDING DATE AS STRING IN DATE COLUMN OF SQL (datetime AS datatype) , data is not inserting in sql table
Thank you very much
Thanks for your watching！ Welcome!
Hi, can you read data back from SQl?
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
干货满满！赞一个！
多谢！欢迎！
Where I can get lsql_microsoft function block
Please help me anyone
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
Please make new program for S7 1500 using new code from Siemens site.
Please find the download link below the video
Sir , please make vedio for file open ,file read and write in twincat 3
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!
@@electricalautomation thanks
Amazing
Thank you! Cheers!
Please make new program for S7 1500 using new code from Siemens site.
Please find the download link below the video