Microsoft KB Archive/93336

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:37, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.