MIDISA Soft

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

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

Every day we write tens lines SQL inquiries. For job to us the good editor who could meet our requirements was required. We couldn't find the ready decision and there was necessity of creation of this editor. This editor is executed "for itself" and contains all demanded functions for job. The basic emphasis became on convenience of use of the editor. Today the editor meets all requirements which the programmer can wish at 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, then the connection to the database will be lost.
• Not ask for my password ... Check this menu item to the program save your password from the database and did not ask him the 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 a field the 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, then this team will do the transfer lines on keywords.
• Replase text. This command replaces the found text in the SQL query on the text that you specify.

• In this menu item displays the saved SQL queries. 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, then the program will display a window where you'll see information about the user program. Name on whom the program is registered.
• Show installed driver. Select this si the menu to see what drivers are installed in the system.
• Home page. If you choose this si the menu, then open this page of our website.
• Forum this program. If you choose this si the menu, then open forum program, which is available on our website.
• News this program. If you select this menu item, then you can subscribe to the RSS news program.

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

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