meta data for this page
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_Extract | 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. |
| ibec_RecompileFunction | Compares the metadata of specified databases and creates a script of all discrepancies. |