Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SELECT statement
Message
From
27/07/2003 19:28:15
 
 
To
21/07/2003 00:28:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811918
Message ID:
00813959
Views:
7
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform