|
On this page you can modify SQL query that ASPRunner.NET has built
for you automatically. In most cases you dont have to change anything
on this page.
Select ID,
OrderDate,
CustomerID
from OrderHeader
 Note:
if you modify default SQL query, make sure that key column(s)
included into fields list. This is required to provide edit/delete functionality.
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
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
WHERE
clause is not supported directly, however, here is the workaround.
Lets assume you use MS Access as database source.
1. Run MS
Access and create new query. Switch to SQL view.
2. Type select
* from customers where customertype='A'
(change this SQL according to your application needs).
3. Save this
query as qryCustomers.
4. Run ASPRunner.NET
and use qryCustomers
as datasource table.
What is not supported
|
