|
|
|
| Structured Query Language (SQL) | SQL is a database industry standard language for retrieving information from relational databases. SQL allows you to select columns and rows from a database (or a set of databases) based on specified conditions. SQL works in a similar way as Filters but is much more flexible. Unlike filters, SQL allows to specify complex query conditions involving more than one database file. The SQL query results can also contain data fields from more than one database file. |
| How to use SQL in DB-HTML Converter? |
Just click on SQL tab in the main screen and, then, click on the Run/Edit SQL Query button. Once you are in the SQL Builder main screen you have to do the
following: - Add one or more tables to the query; - Select the fields (columns) that you want to be included in the query; - Specify the query conditions by clicking on '...' button next to "Where value is" clause; - Run the query by clicking on the "Show Result Table" button. - Once you are happy with the result table click on the OK button to close the SQL Builder window; answer "Yes" in order to save the query result to your hard disk (DB-HTML Converter saves query results in Result.dbf table in Sql subdirectory); - In order to generate an HTML report based on the SQL Query select Result.dbf table in Sql subdirectory (you may want to create an alias for your SQL queries). |
| Note: | SQL Builder contains separate Help file. |
