I am pretty sure this is a race condition and would like to know what is the best way to fix it.
If you look in the General section of this forum there is a posting called FPMI Project Screen Shots. Under there you will find some screen shots of my project. The one I am talking about in this posting is MAINEDIT.
The screen is comprised of many SQL tags. The SQL tags get the data about what number to place on each container and how to address the SQL tags from the SQL Query.
Now if I place the query on the same page as the tags, some of the tags come thru with the overlay stating that they are not available, out of service or quality not good. And they remain this way for a little bit then as the data is updated they change to the proper status and or color.
Now if I place the SQL query on the page that opens the MAINEDIT page and pass it thru the NAV.OPENWINDOW parameters function I dont get the problem of the overlays and quality not good.
The second way is the way that works best but it does not allow me to dynmically change the query from a remote location. If I change the query I have to go back to the page that opens the MAINEDIT and then reopen main edit for the updates. Where as in the first way it does happen dynically but again you get errors on the display.
Thanks for any and all help. Have a great day and wonderful weekend.