Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datasession problems
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00351322
Message ID:
00351339
Views:
22
Do you really mean you open Form2 on Machine 2 first? Is that really Form1 because later you say Machine 2 Form 1 Launch Form 2.

Anyway, let's simplify this a bit. On Machine 1, Open Form 1 and insert a new record, then launch Form2 to see if new record is selected. If not, alternatingly close and reopen the form to see if the record appears. This may be a simple setting on the Server that governs when dirty buffers are actually written to the disk.

When, in Form 1 on Machine 1, when is the tableupdate being performed? IF you issue a tableupdate after inserting the new record, then machine 2 should see the new record.

>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!)
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform