|
• |
EasyStart dialog – Provides explanations and access
to wizards to help you
quickly become productive using dQuery
|
|
• |
Create reusable database connections to: (click on database name for supported versions)
|
|
• |
Create reusable and shareable datamodules (dQuery views) that
can incorporate tables from different databases and different database engines |
|
• |
Base a new datamodule (dQuery view) on an existing one by
“inheriting” from the existing one |
|
• |
Setup ad-hoc parent/child relationships between tables and
store them in a datamodule |
|
• |
View, navigate, edit data from a table |
|
• |
View, navigate mulit-table view containing selected columns
from one or more related tables |
|
• |
Generate report from a multi-table view |
|
• |
Save and customize generated report |
|
• |
Output Report to Window, to Printer, to HTML |
|
• |
Add queries to a datamodule via drag-and-drop or by creating
a SQL statement either via wizards or manually |
|
• |
Create and run queries that prompt the user for input values before running |
|
• |
Filter and sort data on the database server via one or
more of the following:
| SQL Select Wizard |
Walks you through building filter conditions
without having to know SQL |
| Star Filter |
Filter a table via date, character, or
numeric value or range and via foreign key lookups in up to 5 lookup
tables |
| SQL Query Designer |
Used for designing
complex queries and saving them to plain text
files |
| Hand-Code SQL dialog |
Allows users proficient in SQL to manually
enter or paste in SQL code and to create queries to prompt the user
for input before running the query (via parameterized queries) |
|
|
• |
Filter query results on the client machine via one or more
of the following tools (See Note 1):
| SQL Rowset Filter |
Filter via filter conditions built using SQL expressions
(similar to WHERE clause conditions) Walks you through building filter
conditions without having to know SQL. |
| Standard Filter |
Filter via filter conditions built using dQuery’s
dBL language. Walks you through building filter conditions without
having to know dBL |
| Fast Indexed Filter |
Filter based on a value or range on an indexed column |
| Filter By Grid |
Enter values to filter by for table columns in data
grid and then see filtered results within grid |
|
|
• |
Create new table (See Note 2) |
|
• |
Modify structure of a table (See Note 2) |
|
• |
Add/Drop Table Indexes (See Note 2) |
|
• |
Import Wizard: Import data to a table from:
- Database Table
- Excel Spreadsheet
- Text File: Fixed Length Fields, no delimiters (SDF)
- Text File: Comma Separated Values (CSV)
- Text File: Comma Delimited with Quotes
- Text File: Tab Separated Values
|
|
• |
Export Wizard: Export query or multi-table view to:
- New database table
- Add to Existing Database Table
- Excel Spreadsheet
- Text File: Comma Separated Values (CSV)
- Text File: Comma Delimited with Quotes
- Text File: Tab Separated Values
- Text File: Simple Columnar “Report”
- Text File: Fixed Length Fields, no delimiters (SDF)
- HTML File
|
|
• |
Search
- Non-Indexed Search Dialog – finds first row matching a set of
conditions
- Indexed Search Dialog – performs a fast indexed search using
a table’s current index to find the entered value
|
|
• |
Replace Field Value Dialog - Allows you to replace (or
transform) a field value for all rows or a filtered set of rows with a:
- constant value
- value from another field
- result value from a dQuery dBL expression
|
|
• |
Delete Rows Dialog - Allows you to delete all rows or a filtered
set of rows from a table |
|
• |
Calculate Dialog - Allows you to calculate
a Sum, Count, Minimum, Maximum, Average, or Custom value
over all rows or a filtered set of rows for a table
or query. Save result to a text file.
|
|
• |
Print Wizard
- Print automatic report
- Print customized report
- Print data from a table or query
- Print data from a multi-table view
- Print object tree of datamodule
|
|
• |
Report Format Dialog – Allows you to easily customize
an automatic report’s:
- Page Orientation – Portrait or Landscape
- Titles including color and font
- Default output: Printer, Screen, or Web Page
- Show Totals for numeric columns – Yes or No
- Whether to shade alternate lines
- Logo Graphic including size and position
- Page numbering
- Date/Time stamp
|
|
• |
Report Designer - Allows you to create new or customize existing
reports via a graphical object oriented report designer
|
|
• |
One-Click Windows Application Wizard - Uses the datamodule
(dQuery view ) to create and deploy a Windows application that allows you
to view, add, modify, search, or filter data in selected tables and run
reports attached to the datamodule.. |
|
• |
One-Click Web Application Wizard - Uses the datamodule (dQuery
view) to create and deploy a Web application that allows you to view, search,
or filter data in selected tables and run reports attached to the datamodule |
|
• |
Web Wizards
| Remote Data Entry Wizard |
Creates a web page to gather data from a user and a
server side application to receive the data
and store it in a server-side database |
| Query and Response Wizard |
Creates a web page for a user to enter and submit a
query value, a server side application to perform
the requested query, and a report to generate the query results and
return them as a web page. |
| Live or Static Report Wizard |
- Live Report - Allows you to pick a report to deploy
to a web server and link to a web page. Every time a user clicks on the link or enters the report’s
URL the report is re-run on the web server so it can return up-to-date data as a web page.
- Static Report - Allows you to pick and run a report and then publish the resulting report data as a web page to a web server.
|
|
|
• |
dQuery/Web
- Implements a subset of dQuery’s capabilities over the Web
- Allows you to design datamodules (dQuery views), multi-table views,
and simple reports remotely via a web browser.
|
|
• |
Datamodule Source Code Viewer (Business User Install) - Allows
you to view the dQuery dBL source code generated for your datamodule |
|
• |
Source Code Editor (Developer Install) - Allows you to view
and modify the dQuery dBL source code generated for your datamodule or reports |
|
• |
Context sensitive online help |
|
• |
User’s Guide in .pdf format |
|
|
|
|
|
Notes:
1. Not available for large tables (over one million rows)
2. If allowed by user rights, by database configuration, and by driver
|
