|
On this page you can modify SQL query that ASPRunner has built for
you automatically. In most cases you can proceed
with default SQL query.
Select ID,
OrderDate,
CustomerID
from OrderHeader
 Note:
if you modify default SQL query, make sure that key column(s) are
included into fields list. This is required to provide
edit/delete/view functionality.
Also you can enter number of records to appear on
each list page.
If you'd like to specify default sorting order on
the list page (ascending or descending) you can do so by using the
ORDER BY on the list page option.Select necessary fields, move them
to the right window using arrow buttons and choose sorting order by
clicking on the ASC cell (ascending sorting is the default setting).
To switch between tables use Tables
list panel on the left.
What
is supported
Select ID,
OrderDate,
CustomerID,
b.ID as DetailID,
b.Quantity as ProductQuantity
from OrderHeader a
inner join OrderDetail b on
a.ID = b.OrderID
More
info on Using
JOIN SQL queries
Note:
it's recommended to use aliases for fields from joined tables to
avoid confusion when two from different tables have the same name.
Select ProductName,
Quantity,
Price,
Price*0.05 as Tax
from OrderDetails
select *
from customers where customertype='A'
For more complicated
queries wrap condition by brackets:
select *
from customers where (customertype='A'
or customertype='B')
What
is not supported
If your query
for some reason doesn't work create view/query in your database and
use this query as a datasource in ASPRunner.
1. Run MS
Access and create new query. Switch to SQL view.
2. Type your
SQL query there.
3. Save this
query as qryNewQuery.
4. Run ASPRunner
and use qryNewQuery
as datasource table.
|
