IBEBlock documentation
<< IBExpert | Documentation | IBExpertBackupRestore >>
IBEBlock is a set of DDL, DML and other statements that are executed on the server and on the client side, and which include some specific constructions applicable only in IBExpert or IBEScript (excluding the free versions of these products), independent of the database server version.
Important: Namespaces were implemented in IBExpert version 2020.09.13 to divide IBEBlock functions and constants into categories without giving them long names starting with 'ibec_'. All new future functions will be implemented as namespace members. IBEBlock namespace is started with the @ character followed by a namespace name.
Please take a look a the examples at the end of this section, as these demonstrate the true versatility and flexibility of IBExpert's IBEBlocks!
Tutorial
- IBEBlock
- Procedural extensions of IBEBlock
- IBEBlock functions
- String-handling functions
- Mathematical functions
- File functions
- Downloading files
- Server functions
- Database functions
- Database functions (IBExpert only)
- Dataset functions
- Working with XML data
- Working with JSON data
- Mime (Base 64) encoding/decoding functions
- Managing Firebird and InterBase users
- Date and Time functions
- Windows Registry functions
- Functions to handle regular expressions
- Functions for working with FTP servers
- Functions for working with POP3 servers
- HTTP functions
- IMAP functions
- Exception-handling functions
- Dialog and message routines
- Random data routines
- IBExpert functions
- IBEScript.dll interface & callback functions
- Cursor functions
- PSQL functions
- Miscellaneous functions
- IBEBlock examples
IBEBlock
Procedural extensions of IBEBlock
- CREATE CONNECTION deprecated - use ibec_CreateConnection
- USE <connection> deprecated - use ibec_UseConnection
- CLOSE CONNECTION deprecated - use ibec_CloseConnection
- CREATE DATABASE deprecated - use ibec_CreateDatabase
- DROP DATABASE deprecated - use ibec_DropDatabase
- FOR ... DO loops
- FOREACH statement
- SELECT ... AS DATASET
- EXPORT AS ... INTO
- CLOSE DATASET
- EXECUTE IBEBLOCK
- EXECUTE STATEMENT
- INSERT INTO connection.table
- COMMIT
- ROLLBACK
- EXECUTE STATEMENT ... AS DATASET
- FOR EXECUTE STATEMENT ... DO
- TRY ... FINALLY
- TRY ... EXCEPT
- EXCEPTION
- Default values and comments
IBEBlock functions
- String-handling functions
- ibec_Coalesce
- ibec_Copy
- ibec_CopyToClipboard
- ibec_Decode
- ibec_Length
- ibec_Pos
- ibec_PosEx
- ibec_Trim
- ibec_Format
- ibec_CRLF
- ibec_InputQuery
- ibec_PasswordQuery
- ibec_Explode
- ibec_AnsiLowerCase
- ibec_AnsiUpperCase
- ibec_Concat
- ibec_QuotedStr
- ibec_StringReplace
- ibec_StringTurn
- ibec_IBTypeToStr
- ibec_IBTriggerTypeToStr
- ibec_AnsiStringToUTF8
- ibec_UTF8ToAnsiString
- File functions
- ibec_DeleteFile
- ibec_DirectoryExists
- ibec_SetCurrentDir
- ibec_RemoveDirectory
- ibec_FileExists
- ibec_FileSize
- ibec_GetFiles
- ibec_LoadFromFile
- ibec_SaveToFile
- ibec_CopyFile
- ibec_MoveFile
- ibec_FileDateTime
- ibec_SetFileDateTime
- ibec_GetCurrentDir
- ibec_GetRunDir
- ibec_ExtractFileDir
- ibec_ExtractFileName
- ibec_ForceDirectories
- ibec_FileAttr
- ibec_SetFileAttr
- ibec_RenameFile
- ibec_fs_CloseFile
- ibec_fs_Eof
- ibec_fs_OpenFile
- ibec_fs_Position
- ibec_fs_Readln
- ibec_fs_ReadString
- ibec_fs_Seek
- ibec_fs_Size
- ibec_fs_SetSize
- ibec_fs_Writeln
- ibec_fs_WriteString
- ibec_fs_ReadByte
- ibec_fs_WriteByte
- ibec_fs_ReadWord
- ibec_fs_WriteWord
- ibec_fs_ReadDoubleWord
- ibec_fs_WriteDoubleWord
- ibec_fs_ReadInt32
- ibec_fs_WriteInt32
- ibec_ini_Open
- ibec_ini_Close
- ibec_ini_ReadString
- ibec_ini_WriteString
- ibec_ini_Clear
- ibec_ini_EraseSection
- ibec_ini_UpdateFile
- ibec_ini_SetStrings
- ibec_ini_GetStrings
- Database functions
- ibec_CreateDatabase
- ibec_OnlineDatabase
- ibec_ShutdownDatabase
- ibec_DropDatabase
- ibec_CreateConnection
- ibec_RegisterFBCryptKey
- ibec_UseConnection
- ibec_CloneConnection
- ibec_CloseConnection
- ibec_GetDefaultConnection
- ibec_RecompileTrigger
- ibec_RecompileProcedure
- ibec_RecompileFunction
- ibec_CompareTables
- ibec_CompareMetadata
- ibec_ExtractMetadata
- Specifying WHERE clauses in ibec_ExtractMetadata
- ibec_BackupDatabase
- ibec_RestoreDatabase
- ibec_SetConnectionProp
- ibec_GetConnectionProp
- ibec_GetUserDBConnection
- Dataset functions
- ibec_CopyData
- ibec_Array
- ibec_ds_Append
- ibec_ds_Cancel
- ibec_ds_Close
- ibec_ds_Delete
- ibec_ds_Edit
- ibec_ds_Eof
- ibec_ds_Bof
- ibec_ds_Export
- ibec_ds_FieldCount
- ibec_ds_FieldName
- ibec_ds_FieldType
- ibec_ds_FieldTypeN
- ibec_ds_First
- ibec_ds_GetField
- ibec_ds_Insert
- ibec_ds_Last
- ibec_ds_LoadFromFile
- ibec_ds_Locate
- ibec_ds_Next
- ibec_ds_Post
- ibec_ds_Prior
- ibec_ds_RecordCount
- ibec_ds_SaveToFile
- ibec_ds_SetField
- ibec_ds_Sort
- Windows Registry functions
- ibec_reg_Open
- ibec_reg_Close
- ibec_reg_OpenKey
- ibec_reg_CloseKey
- ibec_reg_DeleteKey
- ibec_reg_CreateKey
- ibec_reg_WriteString
- ibec_reg_ReadString
- ibec_reg_WriteBool
- ibec_reg_ReadBool
- ibec_reg_WriteDate
- ibec_reg_ReadDate
- ibec_reg_WriteDateTime
- ibec_reg_ReadDateTime
- ibec_reg_WriteTime
- ibec_reg_ReadTime
- ibec_reg_WriteInteger
- ibec_reg_ReadInteger
- ibec_reg_WriteFloat
- ibec_reg_ReadFloat
- Functions for working with FTP servers
- ibec_ftp_OpenSession
- ibec_ftp_CloseSession
- ibec_ftp_Open
- ibec_ftp_Quit
- ibec_ftp_Connect
- ibec_ftp_Disconnect
- ibec_ftp_ChangeDir
- ibec_ftp_MakeDir
- ibec_ftp_RemoveDir
- ibec_ftp_Rename
- ibec_ftp_DeleteFile
- ibec_ftp_FileSize
- ibec_ftp_FileDate
- ibec_ftp_FileDateTime
- ibec_ftp_GetFile
- ibec_ftp_PutFile
- ibec_ftp_LastResponse
- ibec_ftp_GetProperty
- ibec_ftp_SetProperty
- IMAP functions
- ibec_imap_OpenSession
- ibec_imap_CloseSession
- ibec_imap_Connect
- ibec_imap_List
- ibec_imap_SearchMessage
- ibec_imap_SelectFolder
- ibec_imap_StatusFolder
- ibec_imap_FetchMessage
- ibec_imap_FetchHeader
- ibec_imap_AppendMessage
- ibec_imap_DeleteMessage
- ibec_imap_CopyMessage
- ibec_imap_MessageSize
- ibec_imap_GetMessageFlags
- ibec_imap_SetMessageFlags
- ibec_imap_AddMessageFlags
- ibec_imap_DelMessageFlags
- ibec_imap_GetProperty
- ibec_imap_SetProperty
- Miscellaneous functions
- ibec_BuildCube
- ibec_Cast
- ibec_CastEx
- ibec_Chr
- ibec_CmpRecords
- ibec_CmpRecords2
- ibec_CmpVals
- ibec_CompressFile
- ibec_CompressVar
- ibec_CreateReport
- ibec_DecompressFile
- ibec_DecompressVar
- ibec_Exec
- ibec_ExecScript
- ibec_ExecSQLScript
- ibec_ExportReport
- ibec_FormatFloat
- ibec_FormatIdent
- ibec_FreeGlobalVar
- ibec_GetCmdLine
- ibec_GetGlobalVar
- ibec_GetLastError
- ibec_GetObjectScript
- ibec_dbd_GetObjectProp
- ibec_GetStatementPlan
- ibec_GetStatementExplainPlan
- ibec_GetTickCount
- ibec_GetViewRecreateScript
- ibec_GUID
- ibec_High
- ibec_IIF
- ibec_ImportData
- ibec_IndexOfValue
- ibec_IntToHex
- ibec_KillTask
- ibec_Ord
- ibec_ParseCSVLine
- ibec_Pause
- ibec_PrepareStatement
- ibec_Progress
- ibec_ProgressEx
- ibec_GetEnvironmentVariable
- ibec_SetEnvironmentVariable
- ibec_SetGlobalVar
- ibec_SetKillTimer
- ibec_SetLength
- ibec_ShellExecute
- ibec_ShiftRecord
- ibec_Sleep
- ibec_smtp_SendMail
- ibec_WaitForEvent
- ibec_win_GetLastError
IBEBlock examples
- Event Block examples
- REST example
- Change all triggers
- IBExpert file system inventory tips and tricks
- Automatic script execution
- ODBC access
- Extract metadata using IBEBlock
- Comparing databases using IBEBlock
- Comparing scripts with IBEBlock
- Copy table
- Automatic database structure comparison with recompilation of triggers and procedures
- Data Comparer using cursors
- IBEBLOCK and Test Data Generator
- IBExpert "Text to insert" form default Block
- Joining tables from different databases
- Recreating indices 1
- Recreating indices 2
- Inserting files into a database
- Inserting file data into a database
- Importing data from a CSV file
- Importing data from a file
- Export data into DBF
- Export CSV data 1
- Export CSV data 2
- Creating a script from a Database Designer model file
- Creating an UPDATE script with domain descriptions
- IBEBlock User Forms
- Performing a daily backup of the IBExpert User Database
- Disable and enable IBExpert features
- ibec_ftp examples
- Working with POP3 servers
- IMAP example
- JSON example
- Accessing the input and return parameters when executing in a batch file
- Ascertaining the distribution of data pages
back to top of page
<< IBExpert | Documentation | IBExpertBackupRestore >>
Any comments? Send an email to register@ibexpert.biz
COPYRIGHT © 2002-2024 HK-Software, IBExpert Ltd. All rights reserved.
All IBExpert brand and product names are trademarks or registered trademarks of IBExpert Ltd in Malta and other countries. InterBase, Delphi, CodeGear, C++Builder, Delphi/400, Delphi for PHP and JBuilder are trademarks or registered trademarks of Embarcadero Technologies Inc. in the United States and other countries. Firebird is a registered trademark of the FirebirdSQL Foundation. Turbo Pascal is a registered trademark of Borland International, Inc. Sun, Java, JavaScript and Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries. UNIX is a registered trademark in the United States and other countries, exclusively licensed through “The Open Group”. Oracle is a registered trademark of Oracle Corporation in the United States and other countries. All Microsoft brand and product names are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries. AS/400, DB2, IBM, Informix and iSeries are trademarks or registered trademarks of IBM Corporation in the United States and other countries. Linux is a registered trademark of Linux Torvalds. dBASE is a trademark of dataBased Intelligence, Inc. Skype is a registered trademark of Skype Ltd., in the United States and other countries. All other product names mentioned herein and throughout the entire web site are trademarks of their respective owners.
