Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error when adding space in a column alias
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00953842
Message ID:
00954120
Views:
14
Sergey,

Thanks for the addition. Goes to show just how much I've avoided using spaces in column names. *g*

>You're correct that names that doesn't follow the Transact-SQL rules for identifiers mast be quoted. However, the double quotes (ANSI standard) can only de used when SET QUOTED_IDENTIFIER is ON. The square brackets ([]) can be used always and not affected by any settings but they are MS SQL Server specific.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform