DOC: USE Command Incorrectly Documented in Help File & Manual

 Last reviewed: March 14, 1997
Article ID: Q165171
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a
  • Microsoft Visual FoxPro for Macintosh, version 3.0b

SUMMARY

The online Help and the "Visual FoxPro Language Guide" both show the separator between database name and the table name in the USE command as the period (.). This is incorrect. The separator should be the exclamation point.

MORE INFORMATION

Type USE in the command window. Highlight it and press F1. The following is displayed as the syntax: 

   USE [[DatabaseName.]Table
Also the second paragraph under Arguments incorrectly says the following: 

   To open a table not in the current database, qualify the table name
   with the database name, using a period (.) to separate the database and
   tables names. If you don't qualify a table with a database name,
   Visual FoxPro can open tables only in the current database.
Note that the period should be replaced with an exclamation point (!).

REFERENCES

For more information about the correct notation, please see the following article(s) in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q131265
   TITLE     : Use Exclamation Mark (!) Notation for Precise Referencing

Additional query words:
Keywords : FxprgTable vfoxwin kbdocerr
Version : 3.0b 3.0 3.0b 5.0 5.0a
Platform : MACINTOSH WINDOWS
Issue type : kbdocerr

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.