LextEdit

LextEdit provides a simple but useful tool to quickly take MSQL code and convert it in to a section of usable C Code.  In the file menu under "Edit" there is the option "Format Selection for C (MSQL Only)".  This will convert a selected section of MSQL Code in to a string, replacing the variables with '%s', and adding the variable names comma separated at the end so the entire section can be used in C for a sprintf statement.  This can save considerable time when trying to write large C based commands and significatly reduce the number of mistakes when creating the C code.

Example:

MSQL Code:

Converted:

LextEdit provides a way to create a LextEdit based secured connection configuration.  Allowing restrictions on the connection such as "Trace Profiler Only" or "LextEdit Only" to be confiugred. These restriction will prevent the use of a connection to only the supported application. By securing the connection these configurations are locked preventing modification such as the removal of the connection restriction

After creating a connection double click on the open lock icon next to the Configuration Name window. This will will prompt you for a security phrase, and it will ask to confirm the password which will encrypt the connection information and not allow you to modify it unless you know the security phrase to unlock it.

This would allow a someone to create a special user and password for a connection to share among other users by exporting the connection settings and distributing the export without allowing the recipient to modify the connection configuration.

LextEdit provides some very useful command line arguments that can save you time just but adding them to the windows shortcut.  You can configure it to always start at a certain position and size or you can have it log you in to a system.

-f Used to open a LextEdit window and load a specific file

-t defiines the type of system connection to make.  MSQL to connnect to a Moca based system or ODBC for a SQL database.

-a defines the I.P. address or the DNS name of a system to connect to.

-p the port number that the system can accessed on

-d the type of driver to use to connect to a file or system.

-c used in SQL connection to set Catalog or Database names.

-u a user name to be used at loging for a connection

-w a password to be used at login for a connection

-l sets window position information.

Example 1:

Adding "-t MSQL" as a command line argument will automatically open the "Connection Information" dialog to the "Moca Servers" tab when LextEdit is started.

Example 2:

Adding "-l 0,75,880,920" would always create the window at a position of 0 pixels from the left size of the screen,75 pixels down from the top with a size of 880 wide by 920 tall.

Example 3:

Adding "-a 192.168.1.101 -p 811 -t MSQL -u SUPERVISOR -w SUPERVISOR01" will log in to a MSQL connection at 192.168.1.101 on port 811 for the Supervisor user.

LextEdit provides the ability to open multiple windows from the Tools option on the File Menu.  If you have a connection currently established, all windows opened will connect to that same system.