IBEBlock database functions
The following database-handling functions are available in IBEBlock:
Function | Description |
---|---|
ibec_CreateDatabase | Replaces the CREATE DATABASE command within IBEBlocks. |
ibec_OnlineDatabase | brings the database specified by the Database parameter online using the Firebird Services API. |
ibec_ShutdownDatabase | Performs a shutdown of the database using the Firebird Services API. |
ibec_DropDatabase | Replaces the DROP DATABASE command within IBEBlocks. |
ibec_CreateConnection | Creates an active database connection. |
ibec_RegisterFBCryptKey | Registers a key to allow work with an encrypted Firebird database (Firebird 3). |
ibec_UseConnection | Uses an active database connection. |
ibec_CloneConnection | Clones an existing database connection. |
ibec_CloseConnection | Closes an active database connection. |
ibec_GetDefaultConnection | Returns the default connection. |
ibec_RecompileTrigger | Recompiles triggers. |
ibec_RecompileProcedure | Recompiles stored procedures. |
ibec_CompareTables | Compares the data of specified tables and creates a script of all discrepancies. |
ibec_CompareMetadata | Compares the metadata of specified databases and creates a script of all discrepancies. |
ibec_ExtractMetadata | Extracts metadata (and data if specified) of a database into a script. |
Specifying WHERE clauses in ibec_ExtractMetadata | Allows specification of WHERE clauses for each data table. |
ibec_BackupDatabase | Starts the backup process using the server Services Manager. |
ibec_RestoreDatabase | Starts the restore process using the server Services Manager. |
ibec_SetConnectionProp | Disables the request of the number of affected rows after executing INSERT/UPDATE/DELETE/MERGE statements. |
ibec_GetConnectionProp | Returns the server version of the active connection. |
ibec_GetUserDBConnection | Returns the pointer to the User Database if it is used. |
back to top of page
<< ibec_GetServerLog | IBEBlock | ibec_CreateDatabase >>