Hi Dorin,

I'm back at work now and it seems that the problem may be related to using private data sessions....does that seem reasonable?

I also have a timer in this app and it was keeping certain tables open between events. I've changed it now to close those tables and reopen them only when it needs them. That seems to help. Now my requery is giving the results I expected....now I'm checking for ripple effects to not leaving those tables open.

Do you think that private data sessions could be the reason?
If I'm closing the tables I wouldn't need the FLUSH, would I?

Rick

-----------------------------------------

>I had this problem too.
>Seems that VFP decide itself when to physically write changes to tables on which views are based if there is no FLUSH command. Try to execute FLUSH command after each insert/edit/tableupdate, to be sure that inserts/edits are commited to disk (see SET AUTOSAVE command).
>Dorin
>
>>Hi Nick,
>>
>>User1 was the person who last touched those "most recent records" that user1 doesn't see. Also, there is a timer on the application that checks a table for new content. If that table has new content the timer creates a new Order record and the accompaning OrderItems record. It creates the new items with an empty Closed field, so these items should appear on the form the next time the views are created or requeried.
>>
>>The data is on one server and only accessed by this VFP app and only using views.
>>
>>It's a good thing I like puzzles.
>>Rick
>>-----------------------
>>>Hi Rick,
>>>
>>>Who updated those most recent records that User2 does not see? I assume it is some other app that fills the Work Orders, right? Where are the data stored (some other server, I assume) ?
>>>
>>>
>>>>--------------------------------------
>>>>I'm not sure if this is a VIEW question or a FORM question, but I think it's a VIEW question...
>>>>
>>>>I have a form (WIP) which is to display Work In Progress... Work Orders that are not yet completed, and the form is based on views. The views check the Closed field (a DateTime field) and if closed is EMPTY() then the record should be included in the view and displayed on the form.
>>>>
>>>>The system has only 2 users, User1 and User2, who open the form at about the same time (15-20 seconds apart).
>>>>User1 opens the form first and keeps it open and sees 83 records.
>>>>User2 opens the form second and sees 76 records.
>>>>The records that User2 doesn't see are always the most recent.
>>>>The most recent record entered into the system was about 5 minutes before User1 opened the form. No other work was being done while User1 and User2 opened the form to show us this behavior.
>>>>User2 doesn't see all 83 records unless he exits the application and then goes back in.
>>>>Both users are using the same build of the program and accessing the same base tables.
>>>>
>>>>Does anyone have any idea what may be happening here????
>>>>TIA,
>>>>Rick
>>>>--------------------------------------