We have two forms. They both have a private datasession. The same forms are being run on two machines on the network. The problem is that the new record inserted on Machine 1 is not seen by Machine 2:---
Machine 1 Opens Form 1::
Opens Stran
Sets buffering to 4
Machine 2 Opens Form 2::
Opens Stran
Sets buffering to 4
Machine 1 Form 1
Inserts a record into the Stran file
Machine 2 Form 1
Launch Form2
Machine 2 Form 2::
Open Stran in Private DataSession
No Buffering
Perform SQL on the Stran file - the new record is not extracted.
Close All forms on Machine 2
Load Form1 on Machine 2 and then launch Form2. The SQL runs and the new record is extracted.
Why???
(I hope this is clear enough! - but we've spent 1 day looking at it!)
regards
Ian