TDBISAMSession Component

Removed Properties, Methods and Events

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

Properties

Removed

Description

CurrentServerUser	This property is no longer necessary. ElevateDB uses SQL for procedures and functions.
PrivateDir	This property is no longer necessary. ElevateDB uses one temporary tables property setting, the TempTablesPath property, for all sessions.
RemoteEncryptionPassword	This property is no longer necessary. ElevateDB uses one encryption password per application for all encryption, and it is represented by the EncryptionPassword property.
RemoteParams	This property is no longer necessary. ElevateDB uses SQL for procedures and the TEDBStoredProc component for executing the procedures.
StrictChangeDetection	This property is no longer supported. ElevateDB does not support strict change detection.

Methods

Removed

Description

AddPassword GetPassword RemoveAllPasswords RemotePassword	These methods are no longer supported. ElevateDB offers a complete user security architecture that surpasses simple password access to individual tables. Please see the User Security topic for more information.
AddRemoteDatabase ModifyRemoteDatabase DeleteRemoteDatabase GetRemoteDatabase GetRemoteDatabaseNames	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.
AddRemoteDatabaseUser ModifyRemoteDatabaseUser DeleteRemoteDatabaseUser GetRemoteDatabaseUser GetRemoteDatabaseUserNames	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.
AddRemoteEvent ModifyRemoteEvent DeleteRemoteEvent GetRemoteEvent GetRemoteEventNames	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.
AddRemoteProcedure ModifyRemoteProcedure DeleteRemoteProcedure GetRemoteProcedure GetRemoteProcedureNames	These methods are no longer necessary. ElevateDB uses SQL to create and drop procedures, and a special Information Schema for storing the available functions in a given database. Please see the CREATE PROCEDURE, DROP PROCEDURE, and Procedures Table topics for more information.
AddRemoteProcedureUser ModifyRemoteProcedureUser DeleteRemoteProcedureUser GetRemoteProcedureUser GetRemoteProcedureUserNames	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.
AddRemoteUser ModifyRemoteUser ModifyRemoteUserPassword DeleteRemoteUser GetRemoteUser GetRemoteUserNames ModifyRemoteUserPassword	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.
CallRemoteProcedure RemoteParamByName SendProcedureProgress	These methods are no longer necessary. ElevateDB uses SQL for procedures and the TEDBStoredProc component for executing the procedures.
DisconnectRemoteSession RemoveRemoteSession	These methods are no longer necessary. ElevateDB uses the DISCONNECT SERVER SESSION and REMOVE SERVER SESSION statements to disconnect and remove server sessions on an ElevateDB Server. You can issue these statements via the new Execute method.
GetRemoteAdminAddress GetRemoteAdminPort GetRemoteAdminThreadCacheSize GetMainAdminAddress GetMainAdminPort GetMainAdminThreadCacheSize	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 address, port, and thread cache size parameters for an ElevateDB server are not configurable remotely and must be configured prior to starting an ElevateDB server.
GetRemoteConfig ModifyRemoteConfig	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.
GetRemoteConnectedSessionCount GetRemoteSessionCount GetRemoteSessionInfo	These methods are no longer necessary. ElevateDB uses SQL to query any ElevateDB server sessions, and a special Configuration database for storing the server sessions on a given ElevateDB server. Please see the ServerSessions Table topic for more information.
GetRemoteLogCount GetRemoteLogRecord	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.
GetRemoteMemoryUsage	This method is no longer supported, and was deprecated in the latest DBISAM versions.
GetRemoteUpTime	This method is no longer supported.
RemoveAllRemoteMemoryTables	This method is no longer supported.
StartRemoteServer StopRemoteServer	These methods are no longer supported. The ElevateDB server cannot be remotely stopped and started.

Events

Removed

Description

OnPassword

This event is no longer supported. ElevateDB offers a complete user security architecture that surpasses simple password access to individual tables. Please see the User Security 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

Active	This property has been renamed to the Connected property.
CurrentRemoteUser	This property has been renamed to the CurrentUser property. ElevateDB requires a user login for both local and remote sessions.
LockProtocol LockRetryCount LockWaitTime	These properties have been renamed and prefixed with "Record" in ElevateDB in order to make clear that these properties deal with row locking exclusively.
ProgressSteps	This property has been changed to the ProgressTimeInterval property, which uses a time interval instead of a fixed number of progress steps to ensure that progress updates still take place in a reasonable span of time irrespective of the length or scope of a given operation.
RemoteUser RemotePassword	These properties have been renamed to the LoginUser and LoginPassword properties, respectively. ElevateDB requires a user login for both local and remote sessions.

Methods

Changed

Description

GetRemoteEngineVersion

This method has been renamed to the GetRemoteServerVersion method.

Events

Changed

Description

OnRemoteLogin	This event has been renamed to the OnLogin event. ElevateDB requires a user login for both local and remote sessions.
OnRemoteTrace	This event uses a different record type for the trace record that is passed as a parameter to the event handler.
OnShutdown OnStartup	These events have been replaced with the BeforeConnect, AfterConnect, BeforeDisconnect, and AfterDisconnect events. Also, the new events apply regardless of whether the session component is configured to run as a remote session or a local session via the SessionType property.

New Properties, Methods, and Events

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

Properties

New	Description

KeepTablesOpen	This property has been moved from the database level to the session level in ElevateDB. This gives the developer the ability to control whether tables should be kept open even in SQL procedures or functions in addition to controlling whether tables should be kept open during normal table and query processing.
RecordChangeDetection	This property was added to allow the developer to specify whether changes to a row will issue a warning exception when the row is updated or deleted. In DBISAM this behavior was not configurable and any changes to a row would cause an #8708 (DBISAM_KEYORRECDELETED) exception to be raised.
SessionDescription	This property allows the developer to specify a description for the session.
SQLStmtCacheSize	This property allows the developer to specify an SQL statement cache size all open databases in the session.
FuncProcCacheSize	This property allows the developer to specify a function/procedure cache size all open databases in the session.
ExcludeFromLicensedSessions	This property specifies whether the current session should be included in the session license count controlled by the TEDBEngine LicensedSessions property for local sessions, or by the ElevateDB Server for remote sessions.

Methods

New	Description

CalculateCRC32ForStream	This method calculates a CRC32 checksum for a stream.
Execute	This method allows you to execute an SQL statement against the special Configuration database. This is useful for performing configuration-level queries or operations.
GetStoredProcNames	This method populates a list with the names of all stored procedures and functions defined within the specified database.
SaveStoreFileToStream	This method loads a store file into a stream.
SaveStreamToStoreFile	This method saves a stream to a store file.
FreeCachedSQLStmts	This method allows you to free all cached SQL statements for a specific open database, or for all open databases.
FreeCachedFuncProcs	This method allows you to free all cached functions/procedures for a specific open database, or for all open databases.

Events

New	Description

None

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap