Microsoft KB Archive/93336

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

SELECT Without INTO Automatically Starts BROWSE

ID: Q93336

The information in this article applies to:

  • Microsoft FoxPro for Windows, versions 2.5 and 2.5a
  • Microsoft FoxPro for MS-DOS, versions 2.5 and 2.5a

SUMMARY

When a SELECT command has no INTO clause, FoxPro places the selected data in a cursor named QUERY and automatically starts the BROWSE command so you can to view the output. You can prevent this behavior from occurring by specifying a cursor name in the SELECT command's INTO clause.

MORE INFORMATION

The following two queries produce the same results in FoxPro version 2.5:

QUERY 1

   SELECT * ;
     FROM CUSTOMER ;
     WHERE CUSTOMER.COMPANY = "B"

QUERY 2

   SELECT * ;
     FROM CUSTOMER ;
     WHERE CUSTOMER.COMPANY = "B" ;
     INTO CURSOR QUERY
   BROWSE NOMODIFY

NOTE: Even though the following example places the data that meets the selection criteria into the QUERY cursor, it does not call the BROWSE command:

   SELECT * ;
     FROM CUSTOMER ;
     WHERE CUSTOMER.COMPANY = "B" ;
     INTO CURSOR QUERY

Additional reference words: FoxDos FoxWin 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgBrowse


Last Reviewed: June 27, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.