Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SELECT statement
Message
From
31/07/2003 00:35:25
 
 
To
27/07/2003 19:28:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811918
Message ID:
00815255
Views:
8
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
Abdul Ahad Khan
CSi
www.csi-pk.com
Previous
Reply
Map
View

Click here to load this message in the networking platform