IBExpert toolbars

The individual IBExpert toolbars are described in detail in this section.

Should you ever experience problems with any of the toolbars in IBExpert, simply delete IBExpert.tb, found in Documents and Settings\<user>\Application Data\HK-Software\IBExpert and then restart IBExpert. A “lost” toolbar can be made visible again by altering the parameter Visible=0 to Visible=1 in IBExpert.tb, for example: 

[TSQLScriptForm.bm.Bar0]
Caption=SQL Editor
...
Visible=1

Toolbar Database

This standard toolbar can be viewed in the main IBExpert window. It can be blended in and out using the IBExpert View Menu / Toolbar (check boxes).

The icons (from left to right) can be used to execute the following operations:

These items can also be found in the main IBExpert Database menu. To alter, customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Edit

This standard toolbar can be viewed in the main IBExpert window. It can be blended in and out using the IBExpert View Menu / Toolbar (check boxes).

The icons (from left to right) can be used to execute the following operations:

  1. Load from File [Ctrl + L]. The downward arrow produces a drop-down list of the most recent files.
  2. Save to File [Ctrl + S]. The downward arrow produces a drop-down list of the most recent files.
  3. Cut [Ctrl + X]
  4. Copy [Ctrl + C]
  5. Paste [Ctrl + V]
  6. Find [Ctrl + F]
  7. Search again [F3]
  8. Replace [Ctrl + R]

These items can also be found in the main IBExpert Edit menu. To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Tools

This standard toolbar can be viewed in the main IBExpert window. It can be blended in and out using the IBExpert View Menu / Toolbar (check boxes).

The icons (from left to right) can be used to execute the following operations:

  1. SQL Editor [F12]
  2. New SQL Editor [Shift + F12]
  3. Query Builder
  4. Script Executive [Ctrl + F12]
  5. SQL Monitor [Ctrl + M]
  6. Search in Metadata [Shift + Alt + F]
  7. Extract Metadata
  8. Print Metadata
  9. User Manager
  10. Grant Manager
  11. Report Manager
  12. Blob Viewer/Editor

These items can also be found in the main IBExpert Tools menu. To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar New Database Objects

This standard toolbar can be viewed in the main IBExpert window. It can be blended in and out using the IBExpert View Menu / Toolbar (check boxes).

The icons (from left to right) can be used to execute the following operations:

These items can also be found in the main IBExpert Database menu, or in the IBExpert DB Explorer by clicking the right mouse key to offer a context-sensitive option for the selected database object. Alternatively [Ctrl + N] can be used in the DB Explorer to create new objects (providing an object type has been selected).

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Domain Editor

The standard toolbar for the Domain Editor includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Table Editor

The standard toolbar for the Table Editor includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar View Editor

The standard toolbar for the View Editor includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to (3) Toolbars|Toolbars.

back to top of page

Toolbar Procedure Editor

The standard toolbar for the Procedure Editor includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Debug Procedure

The toolbar for the Debug Procedure Editor includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Debugger drop-down menu
  2. Drop-down list of registered databases
  3. Toggle breakpoint [F5]
  4. Reset [Ctrl + F2]
  5. Parameters [Shift + Ctrl + P]
  6. Run [F9]
  7. Pause [Ctrl + P]
  8. Skip statement
  9. Step Over [F8]
  10. Trace Into [F7]
  11. Run to cursor [F4]
  12. Debug mode (Careful or Fast)

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Trigger Editor

The standard toolbar for the Trigger Editor includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Generator Editor

The standard toolbar for the Generator Editor includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Exception Editor

The standard toolbar for the Exception Editor includes the following icons:

The second Filter by option offers a list of filter options: Name, Text and Description.

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar SQL Editor

This toolbar can be viewed in the Tools / SQL Editor dialog and includes the following icons:

The Query Manager icon allows you to move, remove and rename the most recently used queries.

Individual icons can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

It is also possible to quickly change the Transaction Isolation Level (TIL) for a separate SQL Editor. There is a corresponding button on the right-hand side of the SQL Editor toolbar which allows selection of one of the following isolation levels: Snapshot, Read committed, Read-only table stability, Read-write table stability.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Navigation

The navigational toolbar can be found on the Table Editor's Data page, the View Editor's Data page and in the SQL Editor on the Results page and includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Apply filter [Ctrl + Alt + A]
  2. Show Filter Panel [Ctrl + Alt + F]
  3. Quick Add Filter Criteria
  4. Record Number
  5. Data Analysis
  6. Show summary footer
  7. Display data as Unicode [F3]
  8. First
  9. Previous
  10. Next
  11. Last
  12. Insert
  13. Delete
  14. Edit
  15. Save Updates
  16. Cancel Updates
  17. Refresh

To the right the number of records fetched is displayed.

back to top of page

Toolbar Filter Panel

The Filter Panel toolbar can be found on the Table Editor's Data page, the View Editor's Data page and in the SQL Editor on the Results page when the Show Filter Panel is activated, and includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Apply Filter [Ctrl + Alt + A]
  2. Add New Criteria [Ins]
  3. Delete Criteria [Ctrl + Del]
  4. Vertical Layout [Shift + Ctrl + L]
  5. Count Records
  6. Count filtered records automatically (checkbox option)

back to top of page

Toolbar SQL Query Builder (Visual Query Builder)

This toolbar can be viewed in the Tools / SQL Query Builder dialog and includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Data Analysis (PivotCubeForm)

This toolbar can be viewed in the Tools / Data Analysis dialog. The icons (from left to right) can be used to execute the following operations:

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Script Executive

This toolbar can be viewed in the Tools / Script Executive dialog and includes the following icons:

The first item on the left, the drop-down menu detailing the most important operations, also includes the all-important Add CONNECT statement.

To alter, customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Dependencies Viewer

This toolbar can be viewed in the Tools / Dependencies Viewer dialog and includes the following icons:

  1. Refresh
  2. Clear All
  3. Print
  4. Stop
  5. Max level
  6. Don't check domain dependencies (checkbox)
  7. Show domains [Ctrl + D]
  8. Show tables [Ctrl + T]
  9. Show views [Ctrl + V]
  10. Show triggers [Ctrl + R]
  11. Show procedures [Ctrl + P]
  12. Show generators [Ctrl + G]
  13. Show exceptions [Ctrl + E]
  14. Show UDFs [Ctrl + U]

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar SP/Triggers/Views Analyzer

This toolbar can be viewed in the Tools / SP/Triggers/Views Analyzer dialog and includes the following icons:

S All SELECT statements are selected, analyzed and displayed.
U All UPDATE statements are selected, analyzed and displayed.
I All INSERT statements are selected, analyzed and displayed.
D All DELETE statements are selected, analyzed and displayed.
P Analysis of plans and indices.
TC Analysis of the compatibility of types of return values and variables for SELECT…INTO and OR SELECT…INTO statements.
CW Displays all compiler warnings.
PK Checks primary keys.

back to top of page

Toolbar Extract Metadata

This toolbar can be viewed in the Tools / Extract Metadata dialog and includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Print Metadata

This toolbar can be viewed in the Tools / Print Metadata dialog and includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Select database including a drop-down list of available databases.
  2. Preview
  3. Print

To alter, customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Grant Manager

This toolbar can be viewed in the Tools / Grant Manager dialog and includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Grants

This toolbar can be viewed in the Tools / Grant Manager dialog under Grants on, as well as in the Table Editor on the Grants page, and includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Grant All
  2. Grant All with GRANT OPTION
  3. Grant to All
  4. Grant to All with GRANT OPTION
  5. Grant All to All
  6. Revoke All
  7. Revoke from All
  8. Revoke All from All

back to top of page

Toolbar Localize IB Messages

This toolbar can be viewed in the Tools / Localize IB Messages dialog and includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Load from File
  2. Save to File
  3. Revert to original
  4. Go to line number
  5. Find text
  6. Find next
  7. Export to Text File
  8. Import from Text File

back to top of page

Toolbar Localize IBExpert

This toolbar can be viewed in the Tools / Localize IBExpert dialog and includes the following icons:

The icons (from left to right) can be used to execute the following operations:

  1. Save to File
  2. Find
  3. Search Again
  4. Export to Text File
  5. Import from Text File
  6. Font Charset (drop-down list)

back to top of page

Toolbar Report Manager

This toolbar can be viewed in the Tools / Report Manager dialog and includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Blob Viewer/Editor

This toolbar can be viewed in the Tools / Blob Viewer/Editor dialog and includes the following icons:

These can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbars Database Designer

These toolbars can be viewed in the Tools / Database Designer dialog. They comprise for individual toolbars and include the following icons:

Should IBExpert not load the toolbars automatically after starting the Database Designer, delete IBExpert.tb from the \Documents and Settings\<user>\Application Data\HK-Software\IBExpert\ directory and restart IBExpert.

The individual menus are as follows:

1. Palette

The icons (from left to right) can be used to carry out the following operations:

  1. Pointer
  2. Zoom in
  3. Zoom out
  4. Table
  5. New View
  6. Comment Box
  7. Reference

2. Main

3. Layout

4. Font / Colors

The icons displayed in the Main, Layout and Font / Colors toolbars can be blended in and out by clicking the downward arrow to the right of the toolbar, and using the menu item Add or Remove Buttons to check the relevant icons in the menu list. Custom colors are saved in and restored from a grc file.

To customize or reset these toolbars, please refer to Toolbars.

back to top of page

ODBC Viewer

The ODBC Viewer toolbar offers the following options:

  1. Display the active database connection type
  2. Run [F9] - runs an SQL
  3. Export data
  4. Exports data to script/file
  5. Cursor type: here a choice is offered of Forward Only, Static, Key Set, Dynamic.

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Server Properties/Log

This toolbar can be viewed in the Services / Server Properties/Log dialog and includes the following icons:

  1. Select server (drop-down list of available servers)
  2. Retrieve
  3. Preview Log Report
  4. Print

To customize or reset this toolbar, please refer to Toolbars.

back to top of page

Toolbar Database Statistics

This toolbar can be viewed in the Services / Database Statistics dialog and includes the following icons:

To customize or reset this toolbar, please refer to Toolbars.