Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual FoxPro
Visual FoxPro 9.0 SP2
Microsoft Visual FoxPro 9.0 SP2
Reference
Language Reference
Commands
SET Command Overview
SET ALTERNATE Command
SET ANSI Command
SET ASSERTS Command
SET AUTOINCERROR Command
SET AUTOSAVE Command
SET BELL Command
SET BLOCKSIZE Command
SET BROWSEIME Command
SET CARRY Command
SET CENTURY Command
SET CLASSLIB Command
SET CLOCK Command
SET COLLATE Command
SET COLOR OF SCHEME Command
SET COLOR SET Command
SET COMPATIBLE Command
SET CONFIRM Command
SET CONSOLE Command
SET COVERAGE Command
SET CPCOMPILE Command
SET CPDIALOG Command
SET CURRENCY Command
SET CURSOR Command
SET DATABASE Command
SET DATASESSION Command
SET DATE Command
SET DEBUGOUT Command
SET DECIMALS Command
SET DEFAULT Command
SET DELETED Command
SET DEVELOPMENT Command
SET DEVICE Command
SET ECHO Command
SET ENGINEBEHAVIOR Command
SET ESCAPE Command
SET EVENTLIST Command
SET EVENTTRACKING Command
SET EXACT Command
SET EXCLUSIVE Command
SET FDOW Command
SET FIELDS Command
SET FILTER Command
SET FIXED Command
SET FULLPATH Command
SET FUNCTION Command
SET FWEEK Command
SET HEADINGS Command
SET HELP Command
SET HOURS Command
SET INDEX Command
SET KEY Command
SET KEYCOMP Command
SET LIBRARY Command
SET LOCK Command
SET LOGERRORS Command
SET MACKEY Command
SET MARGIN Command
SET MARK OF Command
SET MARK TO Command
SET MEMOWIDTH Command
SET MESSAGE Command
SET MULTILOCKS Command
SET NEAR Command
SET NOCPTRANS Command
SET NOTIFY Command
SET NULL Command
SET NULLDISPLAY Command
SET ODOMETER Command
SET OLEOBJECT Command
SET OPTIMIZE Command
SET ORDER Command
SET PALETTE Command
SET PATH Command
SET PDSETUP Command
SET POINT Command
SET PRINTER Command
SET PROCEDURE Command
SET READBORDER Command
SET REFRESH Command
SET RELATION Command
SET RELATION OFF Command
SET REPORTBEHAVIOR Command
SET REPROCESS Command
SET RESOURCE Command
SET SAFETY Command
SET SECONDS Command
SET SEPARATOR Command
SET SKIP Command
SET SKIP OF Command
SET SPACE Command
SET SQLBUFFERING Command
SET STATUS BAR Command
SET STATUS Command
SET STEP Command
SET STRICTDATE Command
SET SYSFORMATS Command
SET SYSMENU Command
SET TABLEPROMPT Command
SET TABLEVALIDATE Command
SET TALK Command
SET TEXTMERGE Command
SET TEXTMERGE DELIMITERS Command
SET TOPIC Command
SET TOPIC ID Command
SET TRBETWEEN Command
SET TYPEAHEAD Command
SET UDFPARMS Command
SET UNIQUE Command
SET VARCHARMAPPING Command
SET VIEW Command
Expand Minimize
This topic has not yet been rated - Rate this topic

SET SQLBUFFERING Command

Visual Studio 2005

Specifies if data in a SQL - SELECT statement is based on buffered data or data written to disk.

Copy 

SET SQLBUFFERING ON | OFF

Parameters

ON

Specifies that the SQL - SELECT statement uses local buffered data if available. If data is not buffered, then data from disk is used.

OFF

(Default) Specifies that the SQL - SELECT statement uses data from disk.

This SET command is scoped to the current data session. If you want more control at the table level, use the WITH (BUFFERING = ON | OFF) clause in the SQL - SELECT statement. It overrides the SET SQLBUFFERING statement.

You can use SET(“SQLBUFFERING”) to query the current setting.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.