NT Extension Performance "Enable File Cache"

[Richard I]

Hi
If "Enable File cache" is Unticked, will that prevent Server side caching of  CSV files
Once the CSV file has been served?
Thanks
Richard NT 11.19

[Bruce]

>> If "Enable File cache" is Unticked, will that prevent Server side caching of  CSV files

yes, although that's not the best solution for you. And I suspect may not even be a working solution for you.

From your many threads on this I get the feeling you are not just downloading the file, but using a redirection technique, such as in example 40, to get the file. I think this is probably the wrong approach.

So maybe make an example of the technique you are using, and let's go from there.

In case you're wondering, if it was me, I'd
a) make a browse with the data on it
b) add a SendTo button which would send the browse data to Excel.

Or, if that was not a possibility for some reason, I would

a) make a memory form with a progress bar and Start button and
b) generate the CSV in a source procedure, updating the progress bar, then allowing the user to directly download the file once it has been created.

cheers
Bruce

[Richard I]

Thanks Bruce
You say in  option b -which is the only option in this case for the client...
"generate the CSV in a source procedure, updating the progress bar, then allowing the user to directly download the file once it has been created."

I create the CSV file in the report Validate Button Server Side Code
The resultant CSV file now called $$$Hallname.csv  and  is saved to the app directory on the server
How would I make it available to download directly from there ?
Thanks
Richard

[Bruce]

Hi Richard,

>> I create the CSV file in the report Validate Button Server Side Code

don't do it there.

Rather add a Progress control, and a Start button to the form. Then when the file is created it will be added to the form as a link the user can click to download. (or ir can be set to click automatically.)

cheers
Bruce