Topic group

The dBASE Plus SQL designer lets you create, edit, and execute SQL queries on any supported data source.

You needn’t be an SQL expert to use the SQL designer. In fact, you can use the tool to learn SQL by examining the results and structure of the queries you create. You can start with simple SELECT statements and progress to the most complex table joins and grouped queries—all of which can be easily constructed in the designer’s table pane and notebook pages.

When your statements are structured to produce the results you want, you can save them to disk, edit them with the Source editor, or use them as templates in the SQL Property Builder.

You can also add your saved queries to a dBASE Plus program directly by assigning an .SQL file to the SQL property of a Query object, or by copying statements from your query files directly into your code.