SELECT - SQL Command - WITH Clause

The WITH clause allows you to apply a single command to existing SELECT statements without modifying those statements.

For the complete syntax, see SELECT - SQL Command.

[WITH (BUFFERING = lExpr) ]

Parameters

lExpr

Logical data type. The following table lists the values for lExpr.

lExpr Setting

True (.T.)

Data in the SQL-SELECT statement is based on buffered data, if available.

False (.F.)

(Default) Data in the SQL-SELECT statement is based on data written to disk only.

Expand imageRemarks

Expand imageExample 1

Expand imageExample 2

Expand imageSee Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic