Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SUBSTR (SYS (2015), 3, 10)
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00152929
Message ID:
00153078
Views:
23
Check out the October 1998 FoxPro Advisor, tips section. They mention that after November of this year, SYS(2015) will start generating a string that begins with a numeric character - invalid for cursor/table names. They suggest adding a character, such as "c" for cursor, to the beginning of value.
Mark

>>I'm using VFP 6.0 under Nt4
>>
>>when i use substr(sys(2015), 3, 10). Sometimes i receive a numeric for the first character. Is it possible ???
>>
>>
>>Can anyone help with this?
>>
>>Thanks,
>>
>>Alain
>
>This is a little off topic from your original question (which I think Nancy answered correctly), but if what you want is just the rightmost eight characters from SYS(2015), you would want to use SUBSTR(SYS(2015), 3, 8), or in fact just SUBSTR(SYS(2015), 3), but not (SUBSTR(SYS(2015), 3, 10). Although VFP5, and maybe other versions, lets us get away with using 10, IMHO it's not good programming practice to try to reference past the end of a string.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform