SYS(3099) - SQL Data Engine Compatibility Mode

Enables SQL data engine compatibility with Visual FoxPro 7.0 or Visual FoxPro 8.0.

SYS(3099 [, 70 | 80 ])

Parameters

  • 70
    Specifies that Visual FoxPro treats SQL SELECT commands as it did in versions prior to Visual FoxPro 8.0
  • 80
    Specifies that Visual FoxPro treats SQL SELECT commands with the standard Visual FoxPro 8.0 behavior. For more information, see SET ENGINEBEHAVIOR Command. (Default)

Remarks

Visual FoxPro 7.0 behavior for the SQL SELECT command can be restored by setting SYS(3099) to 70.

See Also

SYS( ) Functions Overview | SELECT - SQL Command | SET ENGINEBEHAVIOR Command | Special Terms for Configuration Files