LextEdit

The Component Lookup window is a quick and easy way to display a Moca Command.  As you type in the Command Name window InteliPrompting automatically populates a list of commands based on your input showing you the commands that are avaliable.  The Show Filter button displays the command names as you type in a grid showing the command name, the component level and a description if populated in the command.

Once a command is selected it will display the Component's Level, the type of command, Local Syntax or C function, show the command in the main text window and populate a grid showing the input arguments to the command.  Components that are C Functions display the contents of the C File that corresponds to the command if available.  When viewing Local Syntax components they can be formatted or you can right click in the main text window and "Open Command File" which will load the corresponding file.

LextEdit automatically generates and stores a history of all commands executed.  A history record consists of the status of the command executed, number of rows returned, total elapsed time of the execution, the command text that was executed, the start time of when it was executed, the row result, the connection string of the system the command was executed against, and what type the connection was.

The History files can be navigated quickly and searched based on the content of the command, the row result, result status, connection string, and connection type.  The Directories tab shows the History folder and any sub folders in the History directory.  By default the sub folders are unchecked to allow for faster searching of more recent history files.

The calendar information shows the days where commands where executed, the graph shows the frequencey of the number of commands executed by hour, and the Sessions can be tied to the graph.  Double clicking on the session will link you back to the session in the History Navigation.

The copy function in the result grid has many functions available.  Use the right click copy to quickly build a "Where" clause, insert statement, or a CSV file all based on what is selected from the grid at the time.  This can save time when it is crucial and eliminate errors by manually retyping data.

Intelipromting uses a cached list of commands, tables, columns, and foreign keys to populate a drop down list as you type.  The list is populated on connection to a MOCA system.  Making learning the tables and columns of a system faster for a beginner or more efficient for even the most knowledgeable user.

Lists of Oracle Functions

The listing of MOCA Commands shows the level and type of command, local syntax or C based function.

After typing the from clause the editor prompts all of the current known tables and filters as you type

When typing the 'where' clause the InteliPrompting presents you with a list of columns avaiable based on the tables from the 'from' clause.  There is an option for all columns, specific columns, foreign key detected, and SQL based functions.