f90SQL - f90SQL-Wizard Features- SQL Editor

F90SQL-Wizard: RAD for f90SQL/Fortran Applications

SQL Editor Utility

The SQL Editor was designed to help you write, test and review the results of SQL queries. Once you have written and tested a query, you can save it to a text file for later use by the SQL Editor, or you can pass it to the Module Wizard to generate a Data Access Module for the query.

You can test your query for syntax errors, invalid options, invalid entity names, etc. SQL Editor offers two different approaches to test a query that you have written; through the ODBC interface and through the ActiveX Data Objects (ADO) interface. Each approach has its advantages depending on the type of query you are writing and the database against which you run the query.

The SQL Editor is also the perfect tool for rapidly creating and executing queries. The SQL Editor can handle any type of queries, like select, insert, delete and update queries. You can also create parameterized queries and use ODBC or your database internal functions.

With the SQL Editor you can create and check the spelling of SQL queries. Just write your query and click the Check button. Any errors in the query will be reported to your immediately. You can check the syntax of queries using the ODBC driver of the database or using an ActiveX Data Objects (ADO) interface.

You can also issue and execute parameterized queries. When you execute the query, the SQL Editor opens a pop-up window requesting the parameters

Of course, you can also see the result set produced by your query.