>The file we are coping is a temp database that we want saved so if they go into the app they have a choice of regernating or looking at the saved data. Currently we use the COPY TO WITH CDX but we were trying to get it faster since I assumed FoxPro didn't just do a DOS copy I since the table I'm coping could have a filter - this one doesn't.
>
>Back in FoxPro 2.6 if you tried the rename across different drives you would get the error message "Attempt to move file to different device." So I didn't know if it now works or I shouldn't use an undocumented feature.
I see. In that case, yeah, you'd likely get a performance boost on a large table, if it's only to be for a quick backup. Don't recall the bug and can't find it listed, but it's been too long, maybe fixed long ago. If it works and suits your needs, looks okay to me.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.