I have a form that queries several database tables to get values depending on a calendar date. I bound the text field of several textboxes to individual SQL queries. These queries collected a sum, but had a fallback value of 0. When I ran the form, it worked just fine on all the PCs I checked it on, in the front office area. I found that the PC in the packaging area, which is many hundred feet away and running Windows XP, had these queries always return the fallback value of 0. I set the query to the relative rate of 100 ms, but it was always still 0 on this PC. I checked another PC running Vista on the desk beside this one and it appeared to work just fine. I checked other PCs running XP in the office area and they work just fine also. I moved the query to a dynamic property on the root container and then it updated correctly on my troubled PC.
Has any reported any issues like this before? Any idea what could have caused this behavior?
Thanks in advance.