The program allows you to create SQL queries. Automatically fill in a SQL queries. Converting syntax of SQL queries (Server - MDB)
Externally usual editor of SQL inquiries with highlight syntax. Open database, start to write SQL inquiry.
To avoid mistakes such opportunity was added:

• View all tables in base Ctrl+Space (it is possible to choose the necessary table).
• Rise the cursor to the end of name of the table and press point, you will see the list of fields, which are in this table.
• After the inquiry is written, press Ctrl+F5 the new window in which there is a table with records will appear.

Every day we write tens of lines of SQL inquiries. For this job a good editor which could meet all our requirements was needed. We couldn't find the ready decision and there was necessity of own editor creation . This editor was designed for myself and contains all demanded functions for my job. The basic emphasis was made on convenience of editor use . Today the editor meets all requirements which the programmer can wish while writing SQL of inquiries.

Description pictures:

• Connect to mdb file. Select this menu item to connect to the database.
• Connect to ODBC ... Select this menu item to connect to the database using the DSN.
• Disconnect from database.If you select this menu item, the connection to the database will be lost.
• Not ask for my password ... Check this menu item and the program will save your password from the database and will not ask it next time you connect.

• Run query. Run SQL query. You must be connected to the database.
• Test SQL query. Checks SQL query for errors.
• Add "From" and "Where". If you use in your tables the field counter and in other table there is an interrelation you can automatically fill SQL query. Example:
  select table1.[fildtable1], table2.[fildtable2]
  from table1, table2
  where table1.[counter_table1] = table2.[counter_table1]

• Insert name table. If you execute this command, the program displays the windows of all tables in the database. Note. You must be connected to the database to use this command.
• Insert name field. If you put a dot at the end of the table, the program displays all the fields that are in this table.

• Delete description ... If you paste text from the program, such as from Visual C + +, the program will clear the string of all characters and leave only the SQL query.
  Example.
  Line before changes: sql.Format("select * from table_name");
  Line after changes: select * from table_name
• Test count ... This menu will calculate the number of open and closed brackets. When the SQL query is very large, it is difficult to avoid syntax errors. Use this menu item to avoid mistakes.
• Convert from MS Server to MDB ... Syntax of SQL queries different. To convert, use this menu item. Example. "case when" to "iif"
• Convert from MDB to MS Server ... Syntax of SQL queries different. To convert, use this menu item. Example. "iif" to "case when"
  • It should be noted that the syntax of SQL Server does not allow perekresnye links within the query. The syntax of SQL server is more strict and not always possible to convert the SQL query.
• Regulate text. If your text is a SQL query string and does not fit in screen size, this command will transfer the lines by keywords.
• Replase text. This command replaces the found text in the SQL query by the text that you specify.

• In this menu item the saved SQL queries displayed . If you want to save the SQL query, press Ctrl + S. The program prompts you to enter a query name. After confirmation, the request will be saved. The name of the query will be displayed only for the database to which the program was connected at the time of preservation.
• If you want to remove SQL query from the list, select it from the list and press the keyboard shortcut Ctrl + Del or Ctrl + D. The program will ask to confirm your action, and after confirmation delete request.
• Be aware that if the program is not connected to the database, you may save the query as a file. In this case, the program will not add the request to the list menu.

• About. If you select this menu item, the program will display a window where you'll see information about the user program. Name for whom the program is registered.
• Show installed driver. Select this item of menu to see what drivers are installed in the system.
• Home page. If you choose this item of menu, the home page of our website will open.
• Forum of this program. If you choose this item of menu, forum program, which is available at our website will open .
• News of this program. If you select this menu item, you will be able to subscribe to the RSS news of the program.

MIDISA SQL Editor 允许你创建SQL查询语句。自动填充查询语句。转换SQL查询语法。外部SQL编辑器具备语法高亮度显示。打开数据库，开始编写SQL查询语句。

为了避免出错添加了以下特性：
- 查看所有表格 Ctrl+Space（选择需要的表）
- 移动鼠标到表名后并点击，你将看到表格对应的输入列表
- 当编辑查询结束后，摁Ctrl+F5对应的查询结果将在新的窗口显示