How to Reset the Active Query/Table Line to <None>

Last reviewed: April 30, 1996
Article ID: Q114655
The information in this article applies to:
  • Microsoft FoxPro for Windows, version 2.6
  • Microsoft FoxPro for MS-DOS, version 2.6

SUMMARY

There is no menu command or push button in Catalog Manager to return the Active Table/Query line to <None>.

However, the methods described below force Catalog Manager to close either the database or the query currently in use.

MORE INFORMATION

When a new catalog is created, the Active Table/Query line at the top of Catalog Manager displays the value <None>. Once a table or query has been used, that table name or query name is listed in the Active Table/Query line until it is removed, or until a new table or query is selected.

WORKAROUNDS

Complete one of the following procedures to set the Active Table/Query line to <None>.

Remove, Then Re-Add the Table or Query in Use

If the table or query in use is not the data source for any of the screens, reports, or labels, do the following:

  1. Select the appropriate tab (either Table or Query). From the File list, select the table or query that is currently in use.

  2. From the File menu, choose Remove File. When you are prompted to remove the file, verify that the Delete File From Disk check box is cleared (not selected), and then choose Remove.

  3. Choose Add. Select the table or query that you removed in step 2 above, and then choose Add.

Add a New Table or Query, Use It, Then Remove It

If the table or query in use is the data source for any of the screens, reports, or labels, it cannot be removed. If another table or query that is not currently part of the catalog is available, do the following:

  1. Select the appropriate tab (either Table or Query).

  2. Choose Add. Select a table or query that is not currently in the catalog, and then choose Add.

  3. Select the table or query that you have just added, and then choose Use.

  4. From the File menu, choose Remove File. When you are prompted to remove the file, verify that the Delete File From Disk check box is cleared (not selected) and that the file selected for removal is the table

        or query that you added in step 2 above.
    

  5. Choose Remove.

Begin to Create a New Query, Then Cancel It

If the table or query in use is the data source for any of the screens, reports, or labels, it cannot be removed. If all other available tables or queries are part of the current catalog, do the following:

  1. Select the Query tab. Choose New, then choose New Query.

  2. Save the query as TEMP.QPR.

  3. When you are prompted to select and open a .DBF file, choose Cancel.

  4. Close the RQBE dialog box.


Additional reference words: FoxDos FoxWin 2.60 catman .dbfs clear all close
databases
KBCategory: kbprg
KBSubcategory: FxtoolRqbe


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: April 30, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.