I have a table open and I am using an alias for it.
I want to sort the table to a temptable .
Then re-establish the sorted table as being used with it's alias. Here is my latest attempt at the code to do that.

SET SAFETY off
SORT TO tempcrime ON crime.crimedate
USE tempcrime
COPY FILE tempcrime TO (pcFileName)
Select 0 && Selects the first available work area
Use (pcFileName) Alias crime
Select crime

I haven't had success so far, but I have been tinkering with this long enough. Is there a VFP guru who can steer me in the right direction, please?