Visual Query Builder (VQB) , SQL. , SQL . , , , .
Visual Query Builder , TQuery , , Query Builder.
. Visual Query Builder Borland C++ Builder . .
Query Builder Databases, (. 1).
. 1.
Visual Query Builder , (. 2).
.2. Visual Query Builder Add Table.
Visual Query Builder , , . 8.1 Visual Query Builder:
1. Visual Query Builder
New | . |
Open | . |
Save As | . |
Options | Options, . |
Table | Add Table, SQL. |
Expression | Expression, , SQL. |
SQL | SQL-. |
Run | . |
OK | SQL TQuery Visual Query Builder. |
Cancel | SQL TQuery Visual Query Builder. |
Help | Visual Query Builder. |
Add Table (. 2) Visual Query Builder . , . Include System Tables, .
. 3. Visual Query Builder ,
:
1. Add Table , Table , .
|
|
2. Add. Visual Query Builder.
3. .2, , Close.
, , . *, .
. 4.
, , . Visual Query Builder , . , , , ( ) . , (. 8.7).
, , Visual Query Builder. Join (.5):
. 5.
, Criteria Visual Query Builder.
Criteria , WHERE SQL (. 2).
2. WHERE SQL-
= | |
> | , |
< | , |
!= | |
like | . |
Between | , , . |
In |
, Criteria, AND. , Name , , Criteria Name LIKE'C%'. AND Name LIKE 'C%' WHERE SQL.
OR OR ( Criteria).
(ascending) (descending) . , Sort, Ascending Descending .
, Option.
- , Option, , Option .
. 6.
, Group Condition, HAVING SQL- SELECT, GROUP BY.
Visual Query Builder . , ..
|
|
, Expression . Expression (. . 7).
. 7. Expression.
Expression , , , , , avg, count, min, max sum. , Expression.
. 8. Options
Options (. 8) , SQL. , , (Remove Duplicate Records), DISTINCT SQL. Options, Options .
, Visual Query Builder. Result Window ( ). , , , . , Run . Result Window, . 8.
. 9. Result Window
, SQL Statement, SQL . SQL. , , SQL Statement (. 10).
. 10. SQL SQL Statement.
Visual Query Builder . SQL TQuery, Visual Query Builder, SQL-.