Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro fails on 11/18/1998
Message
From
18/11/1998 11:47:43
 
 
To
18/11/1998 11:08:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00158805
Message ID:
00158841
Views:
17
>Richard ----
>
>You are correct in that SUBSTR(SYS(2015),3,10) would generate an error today with SELECT ... INTO CURSOR. However, if you are running VFP5 you're obviously in a Win32 environment....why not just use the *whole* SYS(2015) tag for the cursor/tempfile name?

Sometimes we aren't 'blessed' with running on a file system that supports Long File Names; if you aren't careful with old Novell systems, for example, you can be hurt pretty badly by SYS(2015).

>
>
>>This morning (11/18/1998) I came to work to discover that our main VFP 5.0 application was not working in any of our offices.
>>
>>The problem resulted from the fact that we're using SUBSTR(SYS(2015), 3, 10) to create unique names for cursors and temporary tables (Note that this is as reccommended in the VFP documentation under the SYS(3)-Legal File Name topic).
>>
>>On 11/18/1998, the expressesion generates a string beginning with zero. This seems to be the cause of the problem. The solution was simply to preface the expression with a letter (ex: 'T'+SUBSTR(SYS(2015)).
>>
>>If anyone else has experienced the problem today, give this a try!
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform