DOC: USE Command Incorrectly Documented in Help File & Manual (165171)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft Visual FoxPro for Windows 3.0b
  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 5.0a
  • Microsoft Visual FoxPro for Macintosh 3.0b
This article was previously published under Q165171

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:

131265 Use Exclamation Mark (!) Notation for Precise Referencing

Modification Type:MajorLast Reviewed:5/10/2003
Keywords:kbdocerr KB165171
©2002 Microsoft Corporation. All rights reserved.