Thank U David,
I have controlled the problem where I use SYS(2015). The problem that still exists is where I use a SELECT statement INTO a CURSOR.
I think VFP6 also takes the last 8 characters, hence it gives a message:
"Alias 10CBD01 not found"
Or whatever temp file it had generated. Notice that the first character is a NUMBER.
For the time being, I have asked my users to change the System Date to beyond 19th August when running reports. But this is not an elegant solution. In another reply I was told that this problem would go away after 19th Aug, 2003.
Thank U again.
>Either just use SYS(2015) to create your table and alias name or put the underscore ("_") character in front of an alias that would otherwise begin with a digit. Earlier versions of VFP documentation was misleading in suggesting that SUBSTR(SYS(2015), 3) could be used to create a unique file name. True, but is also created illegal alias names as you have found out. If you have VFP 8 there is a note in the help file under SYS(3) which explains the problem.
>
>David