>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