Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro fails on 11/18/1998
Message
From
18/11/1998 21:29:01
 
 
To
18/11/1998 11:00:17
Richard Danley
Tri-B Computer Systems
Hilliard, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00158805
Message ID:
00159092
Views:
22
>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!


Cursors will always be created with unique names....automatically. If you are doing something like:

lcCursor = SYS(2015)
SELECT blah
INTO CURSOR (lcCursor)

you don't have a problem.

For temp tables...is there a reason that you need tables? Won't a cursor work for you there?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform