6/24/2020 8:49 AM | |
Posts: 3 Rating: (1) |
Hello Experts, I'm a newcomer to Siemens Forum I track the guide (https://support.industry.siemens.com/cs/ww/en/view/109779336) and do a lot of stuff. The connection between PLC and SQL server is ok, I've login successfully to SQL. I can ` But when I run ` I have a simple table, I wanna simply read an integer, first with one row! then expand my work. This is my table structure:
and this is my `select` query:
expected result:
Please look at the screenshot, I've attached I've asked the exact same question at StackOverflow, unfortunately, there is any further no documentation over the internet. Any further help, about how to read the return data from `select` query with this simple structure, 1 row, and 1 int value. Thanks a bunch experts,
|
10/30/2020 10:48 PM | |
Joined: 9/21/2006 Last visit: 5/25/2023 Posts: 247 Rating: (65) |
I realize this is an oldish thread, but I did a bit of poking at the https://support.industry.siemens.com/cs/us/en/view/109779336 Application Example, and came up with a function that decodes the the TDS response from MS Server for SELECT queries. You can find an example project (V16) and my notes at [snip]AttachmentS7-1500 Sql.zip (1351 Downloads) |
Last edited by: Jen_Moderator at: 11/02/2020 08:24:48Removed link and added file as an attachment. |
|
This contribution was helpful to3 thankful Users |
11/23/2020 7:31 AM | |
Joined: 4/25/2017 Last visit: 9/24/2024 Posts: 430 Rating: (66) |
Now the example got an update with SELECT queries ;) |
Best Regards, |
|
This contribution was helpful to1 thankful Users |
Follow us on