The Visual Query Builder

With DBxtra creating Queries is really very easy.

You can create Queries from database objects like tables and views and also from exiting DBxtra objects like DBxtra Queries and DBxtra Reports.

You can also create Queries by mixing database objects with DBxtra objects.

Query Designer Interface

Work on several objects at the same time

DBxtra  allows you to work on several objects at the same time.

Each time you load an existing object or create a new one an object tab will be accessible.

Object Path and Data Connection

You can see the Object path and the Data Connection.

 

PaneS

Important!
When working with heavy queries and sub-queries, synchronization between panes might slow down . Therefore  it is recommended to  turn the SQL pane of.

To turn the SQL pane off, select "View" and "SQL Pane" on the menu bar.

 

Underlying Query Objects

When you open a Query you will also see each underlying Query of it.

If you change an underlying Query from these tabs it will only affect the Main Query you are working on.

The underlying Query object itself will not be affected.

Note! If you make changes to the underlying Queries then those changes will be reflected in the Query based on the underlying Query.

Important! If you edit the underlying Query directly from inside the underlying Query tab then the Query object will not be affected; only the main Query.

In this case your Main Queries underlying Query will be disconnected.

Query Synchronization

DBxtra .NET allows full synchronization between  Diagram, Grid and SQL Panes.

Once you change any setting in either Pane all other Panes will be synchronized automatically.

You can also write an SQL syntax manually or paste an existing SQL code and the Diagram and Grid Pane will synchronize.

Movies

Watch Movies

Related

Create a Query

Create a new Query from various Data Sources

Open a Query