I am trying to populate a form with SQL data when a from opens.
- On the internalFrameActivated Event I run a call to a Root Container Script called Populate
event.source.getComponentForPath(‘Root Container’).Populate(system.gui.getParentWindow(event).getComponentForPath(‘Root Container’).Vessel)
- In the Populate Script, I run a SQL Query that is based on a Custom Property for the window that is tied to a PLC Tag.
- I have tried to reference the Custom Property directly and by reference the Property when the data is linked to a label.
- The issue that I am having is that SQL Script is running before the Custom Property is updated, so I am getting data from the previous instance of the form and not the current instance.
So my question is how do I force the SQL Script to run when the Custom Property is updated on Window open?