|
On the Edit SQL query
page you can modify SQL query that ASPRunnerPro has built for you
automatically. In most cases you can proceed
with default SQL query.
This page includes graphical panes that display your SQL
statement ( Query
Designer tab), a text pane that displays the text of
your SQL statement (SQL tab) and result of edited
query as table with values (Results
tab). You can work in either the graphical or text panes and then
check result of executed query. Query Designer synchronizes the
views so they are always current.
Features:
-
Visual interface to design queries.
-
Automatic SQL Statement generation.
-
Create joins with drag and drop.
-
Grid pane to specify criteria (Order By, Group By, Where
etc.).
-
SQL parsing - enter the SQL statement, and the diagram and
grid will be populated.
 Note:
If your
query for some reason doesn't work create view/query in your
database and use this query as a datasource in
ASPRunnerPro.
-
Run MS Access and create new
query. Switch to SQL view.
-
Type your SQL query
there.
-
Save this query as
qryNewQuery.
-
Run ASPRunnerPro and use
qryNewQuery as datasource table.
|
