After months of working correctly, some workstations are failing.
THISFORM.FILEUAC = Alltrim(mxopid)+SUBSTR(SYS(2015), 3, 10)
SELECT 0
CREATE TABLE (AddBS(Sys(2023))+THISFORM.FILEUAC) FREE (UAC C(03), LOB C(03) )
IF USED(THISFORM.FILEUAC)
SELECT (THISFORM.FILEUAC)
USE
ENDIF
USE (AddBS(Sys(2023))+THISFORM.FILEUAC) IN 0 ALIAS UACQuery EXCLUSIVE
SELECT UACQuery
INDEX ON UAC TO (AddBS(Sys(2023))+THISFORM.FILEUAC)
SET INDEX TO (AddBS(Sys(2023))+THISFORM.FILEUAC)
Seems like the stored path in the alias is changing between the excution of the USE and SELECT commands?
The file is created sucessfully, the use of the new file works, but the SELECT UACQuery is wrongly pointing to a different directory than that of the USE command???
Best Regards,
Lee Roy J. Pitre, Jr, AAS, BA, MS
Pitre Computer Consultant & Associates
http://pitres.us