Sql Editor is a program that allows converting SQL queries between SQL Server and MDB formats. Working in this application is quite simple - you just need to insert the SQL code into it, clear it from unnecessary "trash" characters (this is done automatically) and, using the menu, convert the query to the desired format. By connecting to the database, you can execute this query and view the server response from the database. At the same time, the program is able to remember the password to the database and automatically use it for subsequent connections (up to 20 connections to different databases are stored). Sql Editor can also convert SQL queries to C++ format, which allows you to insert them directly into the program code. Using ODBC drivers, you can use Sql Editor to work with virtually any database.
- automatic cleaning of SQL code from "garbage"
- Convert queries from SQL Server format to MDB format and vice versa
- execution of SQL queries to the database