You are not registered yet. Please click here to register!

plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!

Go Back - Interactive Q & A > - Interactive Q & A > LIVE PLC Questions And Answers

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old November 24th, 2022, 09:28 AM   #1

Weo is offline
Join Date: Feb 2006
Location: Sweden
Posts: 82
WinCC Pro - msgFilterSQL

I'm little stucked and ask for small help from one with little more experience of vb script.

So, I have alarm control window Control1[Alarm control] which I need to filter when the screen is loaded. The filter is not constant but indirect (tagprefix).
As you see I added msgbox in end, and can confirm that the tagprefix is correct.

My script is like this today, but is not working:
(The script does work when I add my actual tagprefix as a constant i.e M1)
Guess there should be some wildcard around my prefix and I'm pretty close?

Sub OnGenerateScreen()
Dim prefix
prefix = Parent.Parent.Parent.TagPrefix

ScreenItems("Control1").MsgFilterSQL = "TEXT3 LIKE 'prefix' "

MsgBox prefix
End Sub
  Reply With Quote
Jump to Live PLC Question and Answer Forum

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Wincc rt pro to s7 1500 connection the18 LIVE PLC Questions And Answers 3 November 8th, 2021 04:06 AM
Multiplex tags in WINCC Pro v15.1 dahnuguy LIVE PLC Questions And Answers 24 September 29th, 2020 02:57 PM
WinCC RT Pro / WebNavigator V15.1 and SIMATIC Logon Hal9000 LIVE PLC Questions And Answers 0 July 3rd, 2019 12:46 PM
Citect Vs WinCC - Long Doug_Adam LIVE PLC Questions And Answers 22 October 3rd, 2014 02:56 PM
WINCC PRO V11 build problem with (0 errors, 0 warnings) Yessin LIVE PLC Questions And Answers 0 May 15th, 2013 03:14 AM

All times are GMT -4. The time now is 09:04 PM.