The following miscellaneous functions are available in IBEBlock:
| Function | Description |
|---|---|
| ibec_BuildCube | Builds an OLAP cube using a specified SELECT statement. |
| ibec_Cast | |
| ibec_CastEx | In comparison with the ibec_Cast function, ibec_CastEx doesn't raise an exception if casting is impossible, instead it returns a specified DefaultValue. |
| ibec_Chr | Returns the character for a specified ASCII value. |
| ibec_CmpRecords | Compares two arrays of variants (records). |
| ibec_CmpRecords2 | Compares two arrays of variants (records). |
| ibec_CmpVals | Compares two values. |
| ibec_CompressFile | Allows you to create archives of files and extract them using the ibec_DecompressFile function. |
| ibec_CompressVar | Compresses VALUE using the LZ77 algorithm. |
| ibec_CreateReport | Prepares a report from a specified source (FastReport) and returns prepared report data. |
| ibec_DecompressFile | Allows you to extract files from archives from files compressed using the ibec_CompressFile function. |
| ibec_DecompressVar | Decompresses VALUE preciously compressed with ibec_CompressVar. |
| ibec_Exec | Runs the specified application. |
| ibec_ExecScript | Running a script to create interactive dialogs. |
| ibec_ExecSQLScript | Executes an SQL script from a variable or a file. |
| ibec_ExportReport | Exports a prepared report, created with the ibec_CreateReport function, into a specified format. |
| ibec_FormatFloat | Formats a floating point value. |
| ibec_FormatIdent | Creates a string representation of a GUID. |
| ibec_FreeGlobalVar | Removes a specified variable from a list of global variables, and frees memory associated with the variable. |
| ibec_GetCmdLine | |
| ibec_GetGlobalVar | Returns the value of a specified global variable. |
| ibec_GetLastError | Returns the value of the last failed Windows API call. |
| ibec_GetObjectScript | |
| ibec_dbd_GetObjectProp | |
| ibec_GetStatementPlan | Returns the standard InterBase/Firebird plan of the specified statement. |
| ibec_GetStatementExplainPlan | Returns the extended plan which is available when working with the Firebird 3 server. |
| ibec_GetTickCount | Retrieves the number of milliseconds that have elapsed since Windows was started. |
| ibec_GetViewRecreateScript | Creates a Recreate script for a specified view(s) and returns it as a result. |
| ibec_GUID | Creates a string representation of a GUID, a unique 128-bit integer used for CLSIDs and interface identifiers. |
| ibec_High | Returns the highest value within the range of the index type of the array. |
| ibec_IIF | Tests a condition and returns Value1 if the condition is True and Value2 if the condition is False. |
| ibec_ImportData | Returns the number of imported (inserted) records. |
| ibec_IndexOfValue | |
| ibec_IntToHex | Returns the hex representation of an integer. |
| ibec_KillTask | |
| ibec_Ord | Returns the ordinal value of the specified character. |
| ibec_ParseCSVLine | |
| ibec_Pause | |
| ibec_PrepareStatement | Prepares a DML statement and returns preparation report or raises an error. |
| ibec_Progress | Displays a progress message. |
| ibec_GetEnvironmentVariable | |
| ibec_SetEnvironmentVariable | A wrapper for the Windows API SetEnvironmentVariable function which sets the value of an environment variable for the current process. |
| ibec_SetGlobalVar | Allows you to create/modify a global variable. |
| ibec_SetKillTimer | Terminates an application after the specified interval in minutes. |
| ibec_SetLength | Sets the length of a dynamic-array variable. |
| ibec_ShellExecute | |
| ibec_ShiftRecord | |
| ibec_Sleep | |
| ibec_smtp_SendMail | Sends an email using the SMTP protocol. |
| ibec_WaitForEvent | Monitors events sent by the POST_EVENT command. |
| ibec_win_GetLastError | |
| ibec_ProgressEx |