<< IBExpert | Documentation | IBExpertBackupRestore >>
IBEBlock
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.
| IBEBlock |
- IBEBlock
- Block Editor
- Event Blocks new to IBExpert version 2012.08.19
- ENUM datatype
- Concatenating assignment operator
| Procedural extensions of IBEBlock |
- CREATE CONNECTION
- USE connection
- CLOSE CONNECTION
- CREATE DATABASE
- DROP DATABASE
- 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 new to IBExpert version 2012.05.12
- ibec_Length
- ibec_Pos
- ibec_PosEx new to IBExpert version 2012.11.15
- ibec_Trim
- ibec_Format
- ibec_InputQuery
- ibec_Explode
- ibec_AnsiLowerCase
- ibec_AnsiUpperCase
- ibec_Concat
- ibec_QuotedStr
- ibec_StringReplace
- ibec_AnsiStringToUTF8
- ibec_UTF8ToAnsiString
- ibec_mime_Encode
- ibec_mime_EncodeNoCRLF
- ibec_mime_Decode
File functions- ibec_DeleteFile
- ibec_DirectoryExists
- 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_ini_SetStrings
- ibec_ini_GetStrings
- ibec_fs_Seek
- ibec_fs_Size
- ibec_fs_SetSize
- ibec_fs_Writeln
- ibec_fs_WriteString
- ibec_fs_ReadByte new to IBExpert version 2012.05.12
- ibec_fs_WriteByte new to IBExpert version 2012.05.12
- ibec_fs_ReadWord new to IBExpert version 2012.05.12
- ibec_fs_WriteWord new to IBExpert version 2012.05.12
- ibec_fs_ReadDoubleWord new to IBExpert version 2012.05.12
- ibec_fs_WriteDoubleWord new to IBExpert version 2012.05.12
- ibec_fs_ReadInt32 new to IBExpert version 2012.05.12
- ibec_fs_WriteInt32 new to IBExpert version 2012.05.12
- ibec_ini_Open
- ibec_ini_Close
- ibec_ini_Clear
- ibec_ini_UpdateFile
- ibec_ini_EraseSection
- ibec_ini_ReadString
- ibec_ini_WriteString
Database functions- ibec_CreateDatabase
- ibec_DropDatabase
- ibec_CreateConnection
- ibec_UseConnection
- ibec_CloseConnection
- ibec_RecompileTrigger
- ibec_RecompileProcedure
- ibec_CompareTables
- ibec_CompareMetadata
- ibec_ExtractMetadata
- Specifying WHERE clauses in ibec_ExtractMetadata
- ibec_BackupDatabase
- ibec_RestoreDatabase
- 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_Locate
- ibec_ds_Next
- ibec_ds_Post
- ibec_ds_Prior
- 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
Miscellaneous functions- ibec_BuildCube
- ibec_Chr
- ibec_CmpRecords
- ibec_CmpVals
- ibec_CompressFile
- ibec_CompressVar
- ibec_CreateReport
- ibec_DecompressFile
- ibec_DecompressVar
- ibec_url_DownloadToFile
- ibec_url_DownloadToVar
- ibec_Exec
- ibec_ExecScript
- ibec_ExecSQLScript
- ibec_ExportReport
- ibec_FormatFloat
- ibec_FormatIdent
- ibec_FreeGlobalVar
- ibec_GetGlobalVar
- ibec_GetLastError
- ibec_GetTickCount
- ibec_GetViewRecreateScript
- ibec_GUID
- ibec_High
- ibec_IIF
- ibec_ImportData
- ibec_IntToHex
- ibec_Ord
- ibec_ParseCSVLine
- ibec_Progress
- ibec_Random
- ibec_Random2
- ibec_RandomChar
- ibec_RandomString
- ibec_RandomVal
- ibec_SetEnvironmentVariable
- ibec_SetGlobalVar
- ibec_SetLength
- ibec_ShiftRecord
- ibec_smtp_SendMail
- ibec_WaitForEvent
| IBEBlock examples |
- 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
- Building an OLAP cube
- 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
- Retrieve all valid email addresses from an input text?
- Working with POP3 servers
- Accessing the input and return parameters when executing in a batch file
- Ascertaining the distribution of data pages
| Existing functions not yet categorized and/or documented |
- ibec_ActivateSP
- ibec_ActivateTrigger
- ibec_Cast
- ibec_CloneConnection
- ibec_CmpRecords2
- ibec_CRLF
- ibec_dbd_GetObjectProp
- ibec_DeactivateSP
- ibec_DeactivateTrigger
- ibec_DebugMessage
- ibec_FormatIdent
- ibec_GetDefaultConnection
- ibec_GetEnvironmentVariable
- ibec_http_Abort
- ibec_http_CloseSession
- ibec_http_Data
- ibec_http_Get
- ibec_http_GetAsync
- ibec_http_GetHeader
- ibec_http_GetProperty
- ibec_http_Header
- ibec_http_HeaderSection
- ibec_http_OpenSession
- ibec_http_RcvdCount
- ibec_http_State
- ibec_http_StatusCode
- ibec_IBTriggerTypeToStr
- ibec_IBTypeToStr
- ibec_IndexOfValue
- ibec_OnlineDatabase
- ibec_Pause
- ibec_pkg_AddResource
- ibec_pkg_Create
- ibec_pkg_Free
- ibec_pkg_GetAsString
- ibec_pkg_LoadFromFile
- ibec_pkg_SaveToFile
- ibec_pkg_SetAsString
- ibec_psql_CommentBody
- ibec_psql_ErrorCount
- ibec_psql_Free
- ibec_psql_Parse
- ibec_psql_UnCommentBody
- ibec_psql_UsedObjects
- ibec_SetConnectionProp
- ibec_SetUserProp
- ibec_ShellExecute
- ibec_ShutdownDatabase
- ibec_Sleep
- ibec_StringTurn
back to top of page
<< IBExpert | Documentation | IBExpertBackupRestore >>
Any comments? Send an email to documentation@ibexpert.com
COPYRIGHT © 2002-2013 HK-Software, IBExpert KG. All rights reserved.
All IBExpert brand and product names are trademarks or registered trademarks of IBExpert KG in Germany 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.
