8/2/2020 11:49 AM | |
Joined: 9/27/2019 Last visit: 7/22/2024 Posts: 2 Rating: (0) |
Hello I have exactly the same question. Did you find an efficient solution (no loop) to search for an element in an array in TIA portal, similar to "Select where .." in SQL? Thanks ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 08/03/2020 09:42:48New subject after splitting |
|
8/6/2020 1:53 PM | |
Joined: 10/10/2005 Last visit: 8/29/2024 Posts: 1917 Rating: (136) |
Hello Nick Verboven please find the FAQ (link) and I hope this could be meaningful by you. How do you implement an array access with an S7-1200/S7-1500 with variable index? With best regards |
8/6/2020 2:06 PM | |
Joined: 3/30/2020 Last visit: 9/22/2024 Posts: 4778 Rating: (981) |
The SELECT and WHERE statements are part of higher level code implementation that is SQL. Behind the scenes looping through the list / table still takes place. PLC languages are at a lower implementation level. Your code will have looping. You can create a code block that does SELECT from WHERE. Inside that block looping will occur. |
Last edited by: qwazee at: 08/06/2020 14:06:56Activities of this user is voluntary. There is no obligation or liability placed on this user. Though optional, your 'please' and 'thank you' is highly valued. |
|
8/6/2020 10:04 PM | |
Joined: 7/7/2010 Last visit: 9/20/2024 Posts: 15213 Rating: (2417)
|
If you are an algorithm genius, you can devise a scheme for data storage and some fancy mathematics where data can be stored and retrieved without looping, and instead, just perform some math on the data and out pops the answer(s). The people that created SQL hide the implementation. So, we can assume they are algorithm genius types, or we can assume they were smarter than average, and came up with ways to minimize how much looping they do, and make it seem like it's so fast, hardly any looping was apparently required. I think the latter, but I'm hoping for the first option for any given SQL implementation. If _you_ are one of those algorithm and data architecture genius types, please implement the select / where SQL like functions. However, you might want to consider using someone else's work. Check oscat.de (documentation here: http://www.oscat.de/images/OSCATBasic/oscat_basic333_en.pdf ). Look at BUFFER MANAGEMENT section. Maybe you can use their work as a starting point to create a select where FB.
|
science guy |
|
Follow us on