Skip to Content

Register Login

Default Header

(header konnte nicht geladen werden)

Navigation

Checking valuesz in Optimized DB

Created by: LubomirK at: 11/9/2023 8:37 AM (3 Replies)

Rating (0)

Thanks 0

4 Entries

11/9/2023 8:37 AM	Rate (0)
LubomirK Advanced Member Joined: 4/1/2009 Last visit: 9/9/2025 Posts: 29 Rating: (0)	Hi everyone, I need to check values in the DB (wan to keep it optimized) . Checking values one by one and if the value is out of range then fix it. All values has data type Time. How to fix them I know . The question how go thru the whole DB? I know how to do if the DB is NotOptimized . But how to do if Optimized? And also I do not want to use array because then the name will be same for all ,just different number. I know that now there are similar names but later I want to change them according ele. drawings . The way what I found is do it in HMI . Directly in tag declaration when the value chages . It is working but I want to do it in PLC soft. Thanks for any good Idea . LK Attachment DB_Structure.png (291 Downloads)

Suggestion To thank Quote Answer

11/9/2023 8:38 AM	Rate (0)
LubomirK Advanced Member Joined: 4/1/2009 Last visit: 9/9/2025 Posts: 29 Rating: (0)	It is me just adding the HMI solution LK Attachment HMI_Solution.png (270 Downloads)

Suggestion To thank Quote Answer

11/9/2023 8:57 AM	Rate (0)
jacek d Platinum Expert Joined: 9/23/2005 Last visit: 12/23/2025 Posts: 5149 Rating: (772)	Using optimized DBs requires change in an approach. And this change requires using adequate data structures. In this case an array as this is the only one data structure available which supports traversing. As you do not will to use arrays for other reasons then you know the solution already. LubomirK Checking values one by one and if the value is out of range then fix it. BTW, It's also possible to craft custom timers which have this fixing functionality built-in.
	Regards, Jacek What is confusing you is the fact that you never see a number but always its digit representation. So you end up thinking that the number is the representation. - Andrej Bauer Any claims against me - based on whatever legal reason - resulting from the use of any code and/or ideas presented on this forum shall be excluded. #StayWithUkraine
Suggestion To thank Quote Answer

11/9/2023 11:08 AM	Rate (0)
LubomirK Advanced Member Joined: 4/1/2009 Last visit: 9/9/2025 Posts: 29 Rating: (0)	thx

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on