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

Рет қаралды 9,328

Electrical Automation Hands-On

Күн бұрын

Пікірлер: 35

@rebinshw 3 ай бұрын

The king, absolutely amazing

@electricalautomation 3 ай бұрын

Thanks!

@MahadiHasan-qi1cb 2 жыл бұрын

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 2 жыл бұрын

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

@rebinshw 3 ай бұрын

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

@Rafallaser 3 жыл бұрын

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

@electricalautomation 3 жыл бұрын

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

@Rafallaser 3 жыл бұрын

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

@georgekoutsoudakis2812 4 жыл бұрын

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 4 жыл бұрын

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 4 жыл бұрын

@@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 4 жыл бұрын

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

@sebastianszczerbula8368 4 жыл бұрын

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 4 жыл бұрын

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 7 ай бұрын

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

@WarriorTutoriales 10 ай бұрын

exelente informacion bro .

@electricalautomation 10 ай бұрын

Thanks my friend

@weihuang7228 4 жыл бұрын

干货满满！赞一个！

@electricalautomation 4 жыл бұрын

多谢！欢迎！

@lehel121 4 жыл бұрын

Hi, can you read data back from SQl?

@electricalautomation 4 жыл бұрын

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

@mustaphaboudrik5390 4 жыл бұрын

Thank you very much

@electricalautomation 4 жыл бұрын

Thanks for your watching！ Welcome!

@ag7258 3 жыл бұрын

Where I can get lsql_microsoft function block Please help me anyone

@electricalautomation 3 жыл бұрын

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

@SunilYadav-nb9wp 4 жыл бұрын

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

@electricalautomation 4 жыл бұрын

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 4 жыл бұрын

@@electricalautomation thanks