Share via

Supported Visual FoxPro SET Commands in OLE DB Provider

  • Article

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

SET ANSI Command

SET AUTOINCERROR Command

SET BLOCKSIZE Command

SET COLLATE Command

SET DELETED Command

SET ENGINEBEHAVIOR Command

SET EXACT Command

SET EXCLUSIVE Command

SET FULLPATH Command

SET MULTILOCKS

SET NULL Command

SET PATH Command

SET REPROCESS Command

Note   You can determine the state of many SET commands, supported and unsupported except for SET ANSI, 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