Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select fields which have blank space!
Message
From
31/01/2005 16:51:59
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00982459
Message ID:
00982473
Views:
25
Try putting the field name in square brackets:
SELECT [My Field] FROM table1
>Hi Everybody,
>
>I have fields that might contain blank space in my project. How may I use this fields in a Select SQL command.
>
>It is something like this:
>
>Select My Field form MyTable
>
>“My Field” is my fieldname.
>
>How may I tell to Select command that it is one field?
>
>Thank you,
>Ali
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform