>We are testing our application in a multiuser environment. Data is stored on an NT Server with executables running on local WIN98 machines. Tablebuffering is set to pessimistic row.
>
>In the order entry form, we are intermittently getting items entered on one machine popping up in the grid on the order form on another computer. They are not actually saved in the order, but they continue to pop up on the grid which is extremely confusing.
>
>This is VFP 6.0. Any ideas????? Time is running out.
>
>Bly Maxwell
>DIscovery Unlimited, Inc.
>128 Old Edwards Road
>Arnoldsville, GA 30619

Afternoon Bly,

What you may well find happening is that the update is being forced by the Fox data engine when the record pointer moves off of the record. We use OptimisticRowBuffering, and we don't use the data environment. One of the downsides we have found to the data environment is that it's an all or nothing proposition. If one uses the data environment, one must do things its way.

We've created a data access object that can be instantiated on either the form or the app level. DAO (No relation to the VB construct) manages default or private data sessions, and handles all file manipulation for file share, SQL server, and soon will perform the same functions for ADO recordsets and connections. The idea is to provide a single point of entry to the data. But I digress.

What I'm driving at is that it sounds like tableupdate() is being fired when you don't want it to.

Regards,

Jason