TDBISAMEngine.CreateTempTablesInDatabase Property

CreateTempTablesInDatabase Property

property CreateTempTablesInDatabase: Boolean

Usage

Use the CreateTempTablesInDatabase property to control the location of any temporary tables created by the TDBISAMTable AlterTable, OptimizeTable, or UpgradeTable methods, or their SQL counterparts, the ALTER TABLE statement, the OPTIMIZE TABLE statement, or the UPGRADE TABLE Statement. The default value of this property is False, which means that any temporary tables are stored in the location specified by the TDBISAMSession PrivateDir property. If this property is set to True, then any temporary tables will be created in the current database directory specified by the TDBISAMTable or TDBISAMQuery DatabaseName property, or specified by the TDBISAMDatabase Directory property. This property only applies to the above operations, and does not apply to the temporary tables created by DBISAM for canned query result sets.

Setting this property to True will help avoid any user rights issues that may occur with Windows XP and higher when altering or optimizing tables. Under these operating systems, the rights assigned to any temporary tables created in local directories are usually very restrictive with respect to sharing the table with other users. When the temporary table is copied back to the main database directory once the table alteration, optimization, or upgrade is complete, the table is copied with these restrictive rights. This can make the table inaccessible to other users that need to open, read, or write to the table.

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap