DatabaseManager class

Manages connections and UltraLite databases.

Syntax

public class DatabaseManager

Members

All members of DatabaseManager class, including all inherited members.

Name	Description
createConnectionParms method	Creates and returns an instance of the ConnectionParms object.
createCreationParms method	Creates and returns an instance of the CreationParms object.
createDatabase method	Creates a new database.
dropDatabase method	Erases an existing database that is not currently running.
openConnection method	Opens a new connection to an existing database.
reOpenConnection method	Returns the persistent Connection object previously created or opened.
validateDatabase method	Performs low level and index validation on a database.
AuthStatusCode variable	Readonly property; Holds the AuthStatusCode object.
directory variable	Readonly property; Returns the application directory for AvantGo.
runtimeType variable	Readonly property; Returns the runtime type: standalone or engine/client.
sqlCode variable	Readonly property; Provides error checking capabilities by returning the SQL code value for the success or failure of a database operation.
SQLError variable	Readonly property; Holds the SQLError object.
SQLType variable	Readonly property; Holds the SQLType object.
UL_ENGINE_CLIENT variable	Engine version of UltraLite runtime.
UL_STANDALONE variable	Standalone version of UltraLite runtime.
VALIDATE_EXPRESS variable	Validation input type: do a faster, though less thorough, validation.
VALIDATE_FULL variable	Validation input type: validate tables, indexes, and database.

You must open a connection before carrying out any other operation, and you must close the connection after you have finished all operations on the connection and before your application terminates. You must close all tables opened on a connection before closing the connection.

The DatabaseManager object is the only main PODS object. It is created in the following way:

var dbMgr = CreateObject( "iAnywhere.UltraLite.DatabaseManager.CustDB" );

Note

"iAnywhere.UltraLite.DatabaseManager" is the standard URL prefix to create a DatabaseManager object. The last portion in the URL is the specific application name. Each ULPod application should has its own unique application name.

createConnectionParms method
createCreationParms method
createDatabase method
dropDatabase method
openConnection method
reOpenConnection method
validateDatabase method
AuthStatusCode variable
directory variable
runtimeType variable
sqlCode variable
SQLError variable
SQLType variable
UL_ENGINE_CLIENT variable
UL_STANDALONE variable
VALIDATE_EXPRESS variable
VALIDATE_FULL variable

Discuss this page in DocCommentXchange.