SQL Language Improvements

The SELECT - SQL Command and other SQL commands have been substantially enhanced in Visual FoxPro 9.0. This topic describes the enhancements made to these commands, and new commands that affect SQL performance.

Expand imageExpanded Capacities

Expand imageSubquery Enhancements

Expand imageSub-SELECT in the FROM Clause

Expand imageORDER BY with Field Names in the UNION clause

Expand imageOptimized TOP N Performance

Expand imageImproved Optimization for Multiple Table OR Conditions

Expand imageSupport for Local Buffered Data

Expand imageEnhancements to other SQL Commands

Expand imageSee Also


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