Supported Visual FoxPro SET Commands

  • Article

The Visual FoxPro OLE DB Provider supports the following SET commands.

SET ANSI Command

SET BLOCKSIZE Command

SET COLLATE Command

SET DELETED Command

SET EXACT Command

SET EXCLUSIVE Command

SET FULLPATH

SET MULTILOCKS

SET NULL Command

SET PATH Command

SET REPROCESS Command

Note   The state of many SET commands, including unsupported ones, may be determined by querying the database. For example, the following returns the value for PATH in the resultant cursor.

   SELECT SET('PATH') FROM <sometable> WHERE RECNO()=1

See Also

Language Reference for OLE DB Development | Visual FoxPro OLE DB Provider Data Support | Supported Visual FoxPro Commands and Functions | Unsupported Visual FoxPro Commands and Functions | Supported OLE DB Objects | Standard and Custom OLE DB Properties | OLE DB Provider for Visual FoxPro