Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass Through to Acess Tables with spaces in name
Message
From
07/11/2000 05:11:46
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00438571
Message ID:
00438697
Views:
9
Edmond,

As Vlad mentioned, the easiest way is to examine a remote view. You can use Erik Moore's eView tool to generate the view code into a prg. This allows you to examine all the properties. FWIW, here's what VFP generated when I created a remote view against an Access table containing a field name with embedded spaces:

DBSetProp('AccessTable.field_name_with_space', 'Field', 'UpdateName', 'AccessTable."Field Name with Space"')

Hope this helps.
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform