Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SYS(3) & VARIABLES
Message
From
10/07/2001 12:10:16
David Fluker
NGIT - Centers For Disease Control
Decatur, Georgia, United States
 
 
To
10/07/2001 11:57:29
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00528678
Message ID:
00528702
Views:
19
>>OK thanks.
>
>From the manual:
>
>"SYS(3) may return a non-unique name when issued successionally on a fast computer. Use SUBSTR(SYS(2015), 3, 10) to create unique, legal eight character file name."
>
>"The name that SYS(2015) returns is created from the system date and system time. Calling SYS(2015) more than once during the same millisecond interval will return a unique character string."
>
>Additional notes:
>
  • sys(2015) is 10 characters instead of 8. This may affect some of your procedures.
    >
  • sys(2015) always starts with a character. Not so sys(3).
    >
    >Hilmar.

    A word of caution -
    Yes, sys(2015) always starts with a character, but SUBSTR(SYS(2015), 3, 10) does not. It will generate valid file names, but it can generate invalid eight character variable, field, or table aliases. If you want an eight character unique name use "_" + SUBSTR(SYS(2015), 4, 10) instead.
    David.
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform