>>>>Tend to disagree - I'ld prefer the option to hint on which disc a cursor resides: if your physical writing target is different from your reading source(s), you get a very nice boost on JBOD-machines. Yes I can do this with tables, but why not allow hints ? Even if you have your temp on a separate disk, for multi-step scenarios you have to either resort to temp tables or live with the intermediate results all living on the same HD.
>>>
>>>You could change this in your Config.FPW file.
>>>I doubt you want some cursors to be created somewhere, but others to be created somewhere else.
>>
>>Do you know how can we find within application what Config.fpw file is used? AFAIK there was a new command for that, just don't recall.
>
>
>Oops, I forgot you use VFP8 now. Check:
>
>Setting Configuration Options at Startup and "Specifying an External Configuration File" section of this topic.

Hi Borislav,

I think you misunderstood me. I want to find name and location of config.fpw from inside the application.

We can find resource file, for example, using set('resource',1) command. AFAIK there is a new sys in VFP9 to find config file.