IBExpert keyboard shortcuts

Contents

Main form
Register Database[Shift]+[Alt]+[R]
Unregister Database[Shift]+[Alt]+[U]
Connect to Database[Shift]+[Ctrl]+[C]
Disconnect from Database[Shift]+[Ctrl]+[D] (No effect)
SQL Editor[F12]
New SQL Editor[Shift]+[F12]
SQL Monitor[Ctrl]+[M]
Search in Metadata[Shift]+[Alt]+[F]
Windows Manager[Alt]+[0}
Create User Item from Clipboard[Ctrl]+[V]
Copy User Item to Clipboard[Ctrl]+[C]
Find[Ctrl]+[F]
Replace[Ctrl]+[R]
Search Again[F3]
Incremental Search[Ctrl]+[E]
Delete[Ctrl]+[Del] (No effect)
DB Explorer[F11]
Perfect layout[Ctrl]+[F3] (No effect)
Apply best fit[Ctrl]+[Num] (No effect)
New Subfolder[Shift]+[Ctrl]+[S] (No effect)
Show SQL Assistant[Ctrl]+[A]
Visual Query Builder[Ctrl]+[Alt]+[B] (No effect)
Select Database[Shift]+[Ctrl]+[D] (No effect)

Database Explorer
New Folder[Shift]+[Ctrl]+[F] ([CTRL]+[N]) ??
Delete Folder[Del] ([CTRL]+[Del]) ??
Show SQL Assistant[Ctrl]+[A]
Jump to domains[Ctrl]+[Alt]+[D]
Tables[Ctrl]+[Alt]+[T]
Views[Ctrl]+[Alt]+[V]
Triggers[Ctrl]+[Alt]+[R]
Procedures[Ctrl]+[Alt]+[P]
Generators[Ctrl]+[Alt]+[G]
UDFs[Ctrl]+[Alt]+[U]
Packages[Ctrl]+[Alt]+[K]
Functions[Ctrl]+[Alt]+[F]

SQL Editor
Tables[Ctrl]+[Alt]+[T]
Go to[Alt]+[G]
Cut[Ctrl]+[X]
Copy[Ctrl]+[C]
Select All[Ctrl]+[A]
Commit Transaction[Ctrl]+[Alt]+[C]
Rollback Transaction[Ctrl]+[Alt]+[R]
Export Data[Ctrl]+[E]
Print Table Metadata[Shift]+[Ctrl]+[P]
Previous Query[Ctrl]+[P]
Next Query[Ctrl]+[N]
Delete[Shift]+[Del] ??
Navigate brackets[Shift]+[Ctrl]+[5]
(No opening bracket found, it worked in previous build IIRC)
Toggle case[Shift]+[F3]
Convert to uppercase[Alt]+[Up]
Convert to lowercase[Alt]+[Down]
Execute and fetch all[Shift]+[F9]
Count records[Shift]+[F6]
Clear All History[Shift]+[Ctrl]+[Del] (No effect)
Format query text[Alt]+[F]
Execute current query[Shift]+[Ctrl]+[F9]
Prepare Query[Ctrl]+[F9]
New Query[Shift]+[Ctrl]+[N]
Delete Query[Ctrl]+[D]
Export Data[Ctrl]+[E]
Rename Query[Ctrl]+[F2]
Save to file[Ctrl]+[S]
Load from file[Ctrl]+[L]
List of Domains[Ctrl]+[Alt]+[D]
List of Exceptions[Ctrl]+[Alt]+[E]
List of Fields[Ctrl]+[Alt]+[F]
List of Generators[Ctrl]+[Alt]+[G]
List of Procedure Variables[Ctrl]+[Alt]+[L]
List of Procedures[Ctrl]+[Alt]+[P]
List of SQL Keywords[Ctrl]+[Alt]+[S]
List of Procedure Parameters[Ctrl]+[Alt]+[M] (Not working)
List of Tables[Ctrl]+[Alt]+[T]
List of UDFs[Ctrl]+[Alt]+[U]
List of Views[Ctrl]+[Alt]+[V]
Comment Selected[Shift]+[Alt]+[C]
Uncomment Selected[Shift]+[Alt]+[U]
(Runs Unregister Database)

Functions Editor
Compile function[Ctrl]+[F9]
Execute function[F9]
Debug function[Shift]+[Ctrl]+[D]

To Do List
Refresh ToDo list[F5]

General
Exit[Alt]+[F4]
Compile[F9]
Edit[F2]
Delete[Del]
Undo[Ctrl]+[Z]
Undo all[Shift]+[Ctrl]+[Z]
Script Executive[Ctrl]+[F12]
Incremental Search[Ctrl]+[F] (there is one already , main form)
Execute[F9]
Drop object[Ctrl]+[Del]
Refresh[F5]
Run[F9]
Save[F2] (what about edit [F2]?)
Copy to clipboard[Shift]+[Ctrl]+[C]
Paste from clipboard[Shift]+[Ctrl]+[V]
Format code[Alt]+[F]
Show data[F9] (couldn’t find where it is)
Find Item[Ctrl]+[F]
Edit Item[F2]
Show Toolbar[Ctrl]+[T] (couldn’t find where it is)
Show Snippets Page[Ctrl]+S (couldn’t fine where it is)
Commit Transaction[Ctrl]+[Alt]+[C]
Rollback Transaction[Ctrl]+[Alt]+[R]
Execute[F9]
[Delete All[Shift]+[Ctrl]+[D] (couldn’t find where it is)
Go to[Alt]+[G]
Save Description[F2] (no effect, Save [F2], Edit [F2])

Extract Metadata
Start Extract -[F9]
Extract to[Shift]+[Ctrl]+[T]

Data Tab
Adjust column widths[Ctrl]+[Num] *
Display data as Unicode[F3]

Debugger
Toggle breakpoint[F5]
Step Over[F8]
Reset[Ctrl]+[F2]
Parameters[Shift]+[Ctrl]+[P]
Trace Into[F7]
Run to Cursor[F4]

Grant Manager
Save into New File[Ctrl]+[S]
Append to Existing File[Shift]+[Ctrl]+[S]

Table Editor
Add field[Ins]
Edit Table Structure[F2]
Print Table Metadata[Shift]+[Ctrl]+[P]

Trigger Editor
Compile Trigger[Ctrl]+[F9]

Stored Procedure Editor
Debug procedure[Shift]+[Ctrl]+[D]
Compile procedure[Ctrl]+[F9]
Execute procedure[F9]

View Editor
Compile view[Ctrl]+[F9]

Script Editor
Run from file[Shift]+[F9]
Run Script[F9]

Backup/restore database (IBEBlock)
Open block in Script Executive (and close this window)[Ctrl]+[F12]

Version History
Delete version[Del]
Remove duplicates[Shift]+[Ctrl]+[Del]

Dependency Viewer
Expand Recursive[Ctrl]+[Right]
Collapse Recursive[Ctrl]+[Left]
Remove Node[Ctrl]+[Del]
Drop object[Ctrl]+[Del]
Show domains[Ctrl]+[D]
Show tables[Ctrl]+[T]
Show views[Ctrl]+[V]
Show triggers[Ctrl]+[R]
Show procedures[Ctrl]+[P]
Show exceptions[Ctrl]+[E]
Show generators[Ctrl]+[G]
Show UDFs[Ctrl]+[U]
Show functions[Ctrl]+[F]
Show packages[Ctrl]+[K]

Report Manager
Open report from file[Ctrl]+[O]
Design report[Ctrl]+[D] (not working)

Unknown
New Snippet[Ins]
Compile[Ctrl]+[F9]
Delete Snippet/Folder[Shift]+[Del]
Create Snippet from Clipboard[Ctrl]+[V]
Copy Snippet to Clipboard[Ctrl]+[C]
Autogrant privileges[Ctrl]+[F8]
Autogrant privileges[Shift]+[Ctrl]+[A]
Add New Criteria[Ins]
Delete Criteria[Ctrl]+[Del]
Apply Filter[Ctrl]+[Alt]+[A]
Show Filter Panel[Ctrl]+[Alt]+[F]
Copy Text as RTF[Ctrl]+[W]
Load configuration[Ctrl]+[L]
Save configuration[Ctrl]+[S]
Autogrant privileges[Ctrl]+[F8]
Save Description[Ctrl]+[S]
Compare[F9]
Display exception text as unicode[F3]
Pause[Ctrl]+[P]

<< SQL Assistant | IBExpert | Where to go from here >>