Export not correct

[mmelby]

I have a small system. One windows based program and one web based program. They access the same 2 files on the same Windows server. They both have a function to export a file to csv. The problem is with the web based export. If I delete a record and run the export the deleted record is still in the web based export. It is not in the Windows based export and the record is not found in a browse in either program. If I restart the web based program the record goes away. Note, the web based program runs as a service.

It appears that there is something not being cleared but I have no idea what that could be.

I have attached a text file that contains the code that I use to create the export file.

I would be happy to provide the complete programs if that will help.

Regards,
   Mike

[Jane]

Just taking a WAG here, Mike.  I'd try clearing the "Enable File Cache" checkbox on the web server extension Performance tab.

[Bruce]

yes, if the file is small, and you are generating, then regenerating it, it might be served from the internal server cache. Try turning that off if you are going this route.

Cheers
Bruce

[osquiabro]

Hi Bruce, would that affect a performance of site

[Bruce]

probably not that you'd notice, assuming you have the site in "performance" mode, which I'm guessing you do if you have the cache on.

[mmelby]

Thank you! Turning off file caching has resolved my issue. I have not noticed a performance issue with this setting but it is a very small app.