Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SYS(2023) value within an alias not reliable?
Message
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Title:
SYS(2023) value within an alias not reliable?
Miscellaneous
Thread ID:
00774273
Message ID:
00774273
Views:
53
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
Next
Reply
Map
View

Click here to load this message in the networking platform