TDBISAMEngine Component

Removed Properties, Methods and Events

The following are the properties, methods, and events that have been removed for the component:

Properties

Removed

Description

CreateTempTablesInDatabase	This property is no longer necessary. ElevateDB always creates temporary tables used in optimizing, repairing, or altering tables in the same location as the tables themselves.
FilterRecordCounts	This property is no longer necessary. ElevateDB does not provide logical record numbers (sequence numbers).
Functions	This property is no longer necessary. ElevateDB uses SQL to create and drop functions, and a special Information Schema for storing the available functions in a given database. Please see the CREATE FUNCTION, DROP FUNCTION, and Functions Table topics for more information.
MaxTableBlobBufferCount MaxTableBlobBufferSize MaxTableDataBufferCount MaxTableDataBufferSize MaxTableIndexBufferCount MaxTableIndexBufferSize	These properties are no longer necessary. ElevateDB allows the buffering settings to be set on a per-table basis for each table when the table is created or altered. Please see the CREATE TABLE, ALTER TABLE, and Tables Table topics for more information.
ServerAdminAddress ServerAdminPort ServerAdminThreadCacheSize	These properties are no longer necessary. ElevateDB uses one port for both normal connections and administrative connections, and both types of operations can be performed using only one connection.
ServerConfigPassword	This property is no longer necessary. ElevateDB uses one encryption password per application for all encryption, and it is represented by the EncryptionPassword property.
TableBlobBackupExtension TableBlobTempExtension TableBlobUpgradeExtension TableDataBackupExtension TableDataTempExtension TableDataUpgradeExtension TableIndexBackupExtension TableIndexTempExtension TableIndexUpgradeExtension	These properties have been removed and replaced with the hard-coded value of ".Old". ElevateDB simply appends the ".Old" to the existing file when creating backup copies during the optimization, alteration, or repair of tables.
TableFilterIndexThreshhold	This property is no longer required under ElevateDB and has been removed.
TableMaxReadLockCount	This property is no longer necessary. For performance reasons, ElevateDB does not relinquish read locks when performing table scans in order to satisfy a query or filter condition.
TableReadLockTimeout TableTransLockTimeout TableWriteLockTimeout	These properties are no longer required under ElevateDB and have been removed

Methods

Removed

Description

AddServerDatabase ModifyServerDatabase DeleteServerDatabase GetServerDatabase GetServerDatabaseNames	These methods are no longer necessary. ElevateDB uses SQL to create and drop databases, and a special Configuration database for storing the available databases in a given configuration. Please see the CREATE DATABASE, DROP DATABASE, and Databases Table topics for more information.
AddServerDatabaseUser ModifyServerDatabaseUser DeleteServerDatabaseUser GetServerDatabaseUser GetServerDatabaseUserNames	These methods are no longer necessary. ElevateDB uses SQL to create and drop users and roles, and a special Configuration database for storing the available users and roles in a given configuration. ElevateDB also uses SQL for granting and revoking privileges on databases and other objects for existing users and roles. Please see the CREATE USER, DROP USER, CREATE ROLE, DROP ROLE, GRANT ROLES, GRANT PRIVILEGES, Users Table, Roles Table, UserRoles Table, and DatabasePrivileges Table topics for more information.
AddServerEvent ModifyServerEvent DeleteServerEvent GetServerEvent GetServerEventNames	These methods are no longer necessary. ElevateDB offers jobs, which are the same thing as scheduled events in DBISAM. ElevateDB uses SQL to create and drop jobs, and a special Configuration database for storing the available jobs in a given configuration. Please see the CREATE JOB, DROP JOB, and Jobs Table topics for more information.
AddServerProcedure ModifyServerProcedure DeleteServerProcedure GetServerProcedure GetServerProcedureNames	These methods are no longer necessary. ElevateDB uses SQL to create and drop procedures, and a special Information Schema for storing the available procedures in a given database. Please see the CREATE PROCEDURE, DROP PROCEDURE, and Procedures Table topics for more information.
AddServerProcedureUser ModifyServerProcedureUser DeleteServerProcedureUser GetServerProcedureUser GetServerProcedureUserNames	These methods are no longer necessary. ElevateDB uses SQL to create and drop users and roles, and a special Configuration database for storing the available users and roles in a given configuration. ElevateDB also uses SQL for granting and revoking privileges on procedures and other objects for existing users and roles. Please see the CREATE USER, DROP USER, CREATE ROLE, DROP ROLE, GRANT ROLES, GRANT PRIVILEGES, Users Table, Roles Table, UserRoles Table, and ProcedurePrivileges Table topics for more information.
AddServerUser ModifyServerUser DeleteServerUser GetServerUser GetServerUserNames ModifyServerUserPassword	These methods are no longer necessary. ElevateDB uses SQL to create and drop users, and a special Configuration database for storing the available users in a given configuration. Please see the CREATE USER, ALTER USER, DROP USER, and Users Table topics for more information.
BuildWordList GetDefaultTextIndexParams	These methods are no longer supported. Word generation and text filtering for text indexes is directly tied to the defined text indexes in ElevateDB, so these methods are no longer possible. Please see the Text Indexing topic for more information.
ConvertIDToLocaleConstant ConvertLocaleConstantToID GetLocaleNames IsValidLocale IsValidLocaleConstant	These methods are no longer necessary. ElevateDB uses a special Configuration database for storing the available collations (locales) in a given configuration. Please see the Collations Table topic for more information.
GetServerConfig ModifyServerConfig	These methods are no longer necessary. ElevateDB stores all server startup and operational information in the TEDBEngine component itself, and all additional configuration information, such as the defined databases, users, roles, and jobs, is stored in the server configuration file. The information in the server configuration file can be accessed via the special Configuration database available for each configuration. Please see the Configuration Database topic for more information.
GetServerLogCount GetServerLogRecord	These methods are no longer necessary. ElevateDB logs all error, warning, and information events in a special binary log file available for each configuraton. The information in the log file can be accessed via the special Configuration database available for each configuration. Please see the LogEvents Table topic for more information.
GetServerMemoryUsage	This method is no longer supported, and was deprecated in the latest DBISAM versions.
GetServerSessionInfo	This method is no longer supported. Use the OnServerSessionEvent event along to track session information as sessions are created, connected, etc.
StartAdminServer StopAdminServer StartMainServer StopMainServer	These methods are no longer necessary. ElevateDB uses one port for both normal connections and administrative connections, and both types of operations can be performed using only one connection. In addition, the ElevateDB server is automatically stopped and started when the TEDBEngine Active property is assigned a new value.

Events

Removed

Description

AfterDeleteTrigger AfterInsertTrigger AfterUpdateTrigger BeforeDeleteTrigger BeforeInsertTrigger BeforeUpdateTrigger	These methods are no longer necessary. ElevateDB uses SQL to create and drop triggers, and a special Information Schema for storing the available triggers defined for the tables in a given database. Please see the CREATE TRIGGER, DROP TRIGGER, and Triggers Table topics for more information.
OnDeleteError OnInsertError OnUpdateError	These events are no longer supported.
OnCompress OnDecompress	These events are no longer supported. ElevateDB does not allow for custom compression due to the need for it to run as managed code under .NET.
OnCryptoInit OnCryptoReset OnDecryptBlock OnEncryptBlock	These events are no longer supported. ElevateDB does not allow for custom encryption due to the need for it to run as managed code under .NET.
OnCustomFunction	This event is no longer necessary. ElevateDB uses SQL to create and drop functions, and a special Information Schema for storing the available functions in a given database. Please see the CREATE FUNCTION, DROP FUNCTION, and Functions Table topics for more information.
OnServerConnect OnServerDisconnect OnServerLogin OnServerLogout OnServerReconnect	These events have been removed and replaced with the single OnServerSessionEvent event in ElevateDB. See below for more information on the new OnServerSessionEvent event.
OnServerLogCount OnServerLogEvent OnServerLogRecord	These events are no longer necessary. ElevateDB logs all error, warning, and information events in a special binary log file available for each configuraton. The information in the log file can be accessed via the special Configuration database available for each configuration. Please see the LogEvents Table topic for more information.
OnServerProcedure	This event is no longer necessary. ElevateDB uses SQL to create and drop procedures, and a special Information Schema for storing the available procedures in a given database. Please see the CREATE PROCEDURE, DROP PROCEDURE, and Procedures Table topics for more information.
OnServerScheduledEvent	This event is no longer necessary. ElevateDB offers jobs, which are the same thing as scheduled events in DBISAM. ElevateDB uses SQL to create and drop jobs, and a special Configuration database for storing the available jobs in a given configuration. Please see the CREATE JOB, DROP JOB, and Jobs Table topics for more information.
OnTextIndexFilter OnTextIndexTokenFilter	These events are no longer supported. Word generation and text filtering for text indexes is directly tied to the defined text indexes in ElevateDB, so these methods are no longer possible. Please see the Text Indexing topic for more information.

Property, Method, and Event Changes

The following are the changes to the properties, methods, and events for the component:

Properties

Changed

Description

EngineSignature	This property has been renamed to the Signature property.
LockFileName	This property has been split into two properties. In ElevateDB, the ConfigName property or CatalogName property is combined with the LockExtension property to name the lock file for either the configuration or a given database catalog.
ServerConfigFileName	This property has been split into two properties. In ElevateDB, the ConfigName property is combined with the ConfigExtension property to name the configuration file. The ConfigPath property is used to determine where the configuration file is created. ElevateDB uses a configuration file for local applications as well as the ElevateDB Server, whereas DBISAM only used a configuration file for the DBISAM Database Server.
ServerEncryptionPassword	This property has been renamed to the EncryptionPassword property. ElevateDB uses the EncryptionPassword property for all encryption in the application.
ServerLicensedConnections	This property has been renamed to the LicensedSessions property. ElevateDB supports session count restrictions based upon the LicensedSessions property for both local applications and the ElevateDB server.
ServerMainAddress ServerMainPort ServerMainThreadCacheSize	These properties have been renamed with the "Main" portion stripped out. ElevateDB uses one port for both normal connections and administrative connections, and both types of operations can be performed using only one connection.
TableDataExtension TableIndexExtension TableBlobExtension	These proeprties have renamed to the TableExtension property, the TableIndexExtension property, and the TableBlobExtension property, respectively.

Methods

Changed

Description

AnsiStrToBoolean
AnsiStrToCurr
AnsiStrToDate
AnsiStrToDateTime
AnsiStrToFloat
AnsiStrToTime
BooleanToAnsiStr
CurrToAnsiStr
DateToAnsiStr
DateTimeToAnsiStr
FloatToAnsiStr
TimeToAnsiStr

These methods have been renamed with the "Ansi" portion replaced with "SQL". This was done to reflect that these methods now work with both ANSI strings and Unicode (wide) strings.

Events

Changed

Description

OnServerStart
OnServerStop
OnShutdown
OnStartup

These events have been replaced with the BeforeStart, AfterStart, BeforeStop, and AfterStop events. Also, the new events apply regardless of whether the engine component is configured to run as a client engine or a server engine via the EngineType property.

New Properties, Methods, and Events

The following are the new properties, methods, and events added in the new ElevateDB component:

Properties

New	Description

BackupExtension	This property is used to specify the extension used for ElevateDB backup files. Please see the BACKUP DATABASE, RESTORE DATABASE, and Backups Table topics for more information.
UpdateExtension	This property is used to specify the extension used for ElevateDB update files. Please see the SAVE UPDATES, LOAD UPDATES, and Updates Table topics for more information.
TablePublishExtension	This property is used to specify the extension used for the publish files associated with published ElevateDB tables. Please see the PUBLISH DATABASE, UNPUBLISH DATABASE, and Tables Table topics for more information.
CatalogName CatalogExtension	These two properties are combined together to specify the file name used by ElevateDB for all database catalogs.
LogExtension LogCategories MaxLogFileSize	These properties are used in ElevateDB to control the naming of the log file, what types of events are logged in the log file, and the maximum log file size. ElevateDB combines the ConfigName property with the LogExtension property to name the log file, and the log file is always created in the path specified by the ConfigPath property. The log file in ElevateDB is a ciruclar log file, and the MaximumLogFileSize determines at which file size ElevateDB starts to re-use the log file space of the oldest log entries with the newer log entries.
ServerAuthorizedAddresses ServerBlockedAddresses ServerDeadSessionExpiration ServerDeadSessionInterval ServerMaxDeadSessions ServerSessionTimeout	These properties were added to replace the same server configuration file settings that were available in the DBISAM Database Server.
ServerRunJobs ServerJobCategory	These properties determine whether the ElevateDB Server can run jobs, and if so, what category of jobs it should run.
TempTablesPath	This property specifies where any temporary tables created by the engine will be stored.

Methods

New	Description

GetTempTablesPath	This method returns the operating system-defined temporary files path.
DayTimeIntervalToSQLStr YearMonthIntervalToSQLStr SQLStrToDayTimeInterval SQLStrToYearMonthInterval	These four methods are used to convert SQL intervals, either day-time intervals or year-month intervals, to and from strings. Please see the Interval Types topic for more information.

Events

New	Description

None

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap