GM - SQL Executer

Edit and execute SQL statements and scripts. Screenshots Release Notes Download Windows x86 32-Bit

Features:

• Unlimited number of simultaneous DB connections via ODBC.
• Typing and executing single or multiple SQL statements directly.
• Editing and executing SQL scripts.
• SQL syntax highlighting editor.
• Current statement highlighted by background color.
• Auto-detecting current statement while typing.
• All types of comments recognized.
• Schemata of connected databases can be shown in dock-able TreeViews.
• Schema names can be dragged from the tree nodes into the editor.
• Multiple log settings when executing statements and scripts.
• The log can be saved, copied, searched and printed.
• Result sets of select statements are shown in a data grid allowing direct editing of the data.
• COM Interface for activation of the SQL Executer from other applications.
• Auto-commit or manual commit transactions.
• Recent script files remembered.
• Complete desktop remembered on startup.
• Complete source code included.

Application Parameter

• "GMSqlExecuter.exe /REGSERVER" registers COM classes and interfaces.
• "GMSqlExecuter.exe /UNREGSERVER" unregisters COM classes and interfaces.

Everytime the GM - SQL Executer is manually started it re-registers it's COM classes and interfaces. The COM type library resource is linked to GMSqlExecuter.exe. It can be extracted with any typelib tool.

The COM class registration will fail unless the user who started the application has administrator rights. The Setup will execute the COM class registration and therefore requires administrator rights. Once setup the application can be used even without administrator rights. A failed COM class registration at application startup by a non-admin user will be quietly suppressed unless /REGSERVER parameter has been specified.

Note

• The data presentation of the GM - SQL Executer has been build using the GM-ODBC data access components and the GM-Interface based data aware controls.
• It ships together with the complete source code needed to compile the application.
• The application in the Setup has been build with Delphi 5.0. But the source code will compile with all higher versions of Delphi too.
• Only Delphi standard edition is required to compile the application.
• The application can be compiled even if none of the components used in it has been installed to the compiler. Just press cancel if the IDE complains about missing components or classes when showing forms. Don't press ignore, pressing ignore would delete the component(s).