Altova XMLSpy 2024 Enterprise Edition

The Query Database command opens the Database Query window (screenshot below). Once the Query Window is open, its display can be toggled on and off by clicking either the DB | Query Database command or the Query Database toolbar icon icQueryDatabase.

Click to expand/collapse

 

Overview of the Database Query window

The Database Query window consists of three parts:

 

A Browser pane at top left, which displays connection info and database tables.

A Query pane at top right, in which the query is entered.

A tabbed Results/Messages pane. The Results pane displays the query results in what we call the Result Grid. The Messages pane displays messages about the query execution, including warnings and errors.

 

The Database Query window has a toolbar at the top. At this point, take note of the two toolbar icons below. The other toolbar icons are described in the section, Query Pane: Description and Features.

 

icDBQueryToggleBrowser

Toggles the Browser pane on and off.

icDBQueryToggleResults

Toggles the Results/Messages pane on and off.

 

Overview of the Query Database mechanism

The Query Database mechanism is as follows. It is described in detail in the sub-sections of this section

 

1.A connection to the database is established via the Database Query window. Supported databases include: MS Access 2000 and 2003; Microsoft SQL Server; Oracle; MySQL; Sybase; and IBM DB2.

2.The connected database or parts of it are displayed in the Browser pane, which can be configured to suit viewing requirements.

3.A query written in a syntax appropriate to the database to be queried is entered in the Query pane, and the query is executed.

4.The results of the query can be viewed through various filters, edited, and saved back to the DB.

 

© 2017-2023 Altova GmbH