Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WARNING - SYS(2015) BEHAVIOR!!!
Message
From
19/11/1998 03:23:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00159053
Message ID:
00159140
Views:
22
>Some of you may remember that the help for the SYS(2015) command suggested that to generate an 8 character temp table name, use the following:
> SUBSTR(SYS(2015),3,10)
>
>Today the 3rd digit of SYS(2015) is a "0" (a zero). If you have based your temp table naming logic on this, it will break because an alias cannot start with a numeral.
>
>The third digit will be 0 until November 11, >> 1999 <<.
>
>If your users are all of a sudden calling you with weird problems, this may be a clue.
Gee :) Taking into account that sys(2015) is generated using datetime, I never used that suggestion (and missed it up till now :) and instead added a char in front of whatever part I get it from sys(2015). A simple 8.3 format by sys(2015) :
lcTempFileName = stuff("T"+sys(2015),9,0,".")
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform