LextEdit Features
Custom Commands
- Hits: 7599
LextEdit provides users the ability to construct their own custom commands to be quickly executed. To create a custom command navigate the file menu to "View" and then down to the "Preferences" option. This is where all of the application preferences can be found. Next click on the "Custom Commands" tab.
Commands can be created by right clicking under Custom Commands tree on the right side of the window and selecting the option "Add Command".
Users can also create directories to help group custom commands together to make them easier to find. Custom commands can be built where they take in arguments so when executed a pop-up window appears prompting a user to input the value or values needed by the command.
Once a custom command has been created, a file menu item will now appear in the main LextEdit window with a drop down of all the custom commands.
Component Lookup
- Hits: 6014
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.
Command History
- Hits: 6178
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.
Copy from the Grid
- Hits: 6116
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.
InteliPromt
- Hits: 8668
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.
