Cache problem in runing Foxpro 2.6 on NT 4.0 2

[kanandy]

<br>Anyone knows how to solve the problem of the dbf table is not real-time updated in NT server environmnet. I know somehow the problem in 16 bits application runing on 32 bits server and the cache is not updating into the disk. <br><br>Thanks in advance<br><br><br><br>Andy<br>

 

[foxdev]

Try issuing the FLUSH command and see if that helps. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[stoneman4]

I know it's been a while, but I'm interested to know if this solved kanady's problem. I've got a similar issue in the same environment (DOS FP 2.6 exe on Win98 clients, WinNT 4.0 server) where data written to a dbf opened exclusively is apparantly not being updated on the server before the next client process accesses the table.

This table stores the &quot;next transaction number&quot; for a networked cattle-auction application, and this phenomenon causes grief, to say the least.

I will try the &quot;FLUSH&quot; approach next. Been through everything else

Something else those coding DOS FP apps to run against NT servers should know about is Win NT and 2000's caching file opens &quot;feature&quot;. According to Microsoft, this may raise issues with apps that aren't &quot;NT aware&quot;. MS Knowledgebase article Q124916 gives details on this.

Regards,
WBG

 

[wanewrld]

I had similar problems with Win ME. Disable &quot;write-behind caching&quot; and that should solve the problem. Issuing a FLUSH didn't always work.