My code does not have any FLUSHs in it. And in this case, the person running the report (the "salesperson") does not enter in the data - that is done by back office staff. The sales people like to run their reports throughout the day (particular at month end :-). But they are not entering the data.

I am pretty sure that the person entering the data would have closed the form (and saved) much earlier in the day. Here was the example I tracked down today:

- one sale entered with a timestamp of 12:01 pm (each record is timestamped when saved)
- another sale had a timestamp of 1:02 pm

When I logged in to run the report (at 1:30), I got both sales on the sales report

- when the user who called ran it, he got neither sale showing up (I checked and he logged on at 11:15 am)
- I had him run the report from another user's PC and they got one of the two sales; I checked and she had logged in at 12:36 pm

So that makes sense - she got the sale that happened before she logged in but not the one after.

I would have thought that there was something in VFP that when a query is run, it checks to see if there has been any changes to the table since the last time it opened it and if so, it refreshes its data.

To me the weird part is that if the user runs the report again right away, they get all the data - it's like on a 2nd run VFP decides to pull down the latest data.

Thoughts?

Albert






>Sounds like a data caching issue. Does the code do a FLUSH after a data update to empty the VFP butters? (Note, this will not affect any buffering done one the server)
>
>
>>Hi all,
>>
>>Some users have reported to me that when running "mid-day" reports for their sales, that some of their sales are not showing up in the report. They reported this behaviour:
>>
>>- they go into the report writer and run their sales report. Certain sales that have taken place in the last couple hours are not in the listing.
>>- but then they told me that if they *immediately* run the report again (they do not exit the report writer etc), they get the correct result
>>
>>I tracked it down to some sort of delay if they have had the app open all day to that point or not. That is, if the app has been closed and they fire it up and go the reports screen, they will get the up to date results. But if they perhaps opened up the app at 10:00 am and were working through the day as others put in some sales, then when they go to run the report, it does not show the sales between the time they opened the app and the time they ran the report.
>>
>>- My app keeps tables open in a default data environment after they have been opened for the first time. This was done for speed so that the app was not constantly opening and closing tables on the network.
>>
>>Is this a network thing or is VFP just not refreshing the data when it does a query? Do I need to close all pertinent tables before allowing them to run the report writer?
>>
>>Thanks,
>>
>>Albert