Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Space in dbc name
Message
 
 
To
11/07/2006 17:39:38
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135534
Message ID:
01135634
Views:
11
>I found this accidentally... testing a converter of mine, which was supposed to convert old dos free tables into new tables with a dbc. It was using a directory name as the dbc name, and I forgot that and had a space in the name of the directory. And it still works!
>
>Dbc() returns "M:\RAD\APVFP\OS DZ\DATA\OS DZ.DBC", and when I try to open a table, intellisense kicks in and gives me the proper syntax:
>
>USE "os dz!kupci"
>
>This saves me a bunch of time - just when I thought I'll have to rework the automatic naming :).

From USE command help: "On Microsoft Windows 98 and later, spaces are significant in file names; therefore, avoid using extraneous spaces in TableName and DatabaseName. If a table or database name contains spaces, enclose the name in quotation marks."
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform