Re: Suggestoins for Local DB to use with Shareware
- From: "I.P. Nichols" <nospam@xxxxxxxxxx>
- Date: Sun, 30 Apr 2006 09:37:01 -0400
"Ray Porter" wrote:
I agree. I use Access for all my small installations.<snip>
It doesn't have stored procedures but that's usually a minor adjustment.
I beg to differ - it does have stored procedures and they work pretty much
the same as in MS SQL, you need to setup the calling parameters a little
different but otherwise you can use the same code. In MS Access these are
called "PROCEDURE Clause".
For example the Access version of the ubiquitous NorthWind database has
several stored procedures one of which is named "Employee Sales by Country"
that executes the following:
PARAMETERS [Beginning Date] DateTime, [Ending Date] DateTime;
SELECT DISTINCTROW Employees.Country, Employees.LastName,
Employees.FirstName, Orders.ShippedDate, Orders.OrderID, [Order
Subtotals].Subtotal AS SaleAmount
FROM Employees INNER JOIN (Orders INNER JOIN [Order Subtotals] ON
Orders.OrderID = [Order Subtotals].OrderID) ON Employees.EmployeeID =
Orders.EmployeeID
WHERE (((Orders.ShippedDate) Between [Beginning Date] And [Ending Date]));
.
- References:
- Suggestoins for Local DB to use with Shareware
- From: G . Bradley MacDonald
- Re: Suggestoins for Local DB to use with Shareware
- From: I.P. Nichols
- Re: Suggestoins for Local DB to use with Shareware
- From: Ray Porter
- Suggestoins for Local DB to use with Shareware
- Prev by Date: Re: The Register interview Nigel Brown
- Next by Date: Re: The Register interview Nigel Brown
- Previous by thread: Re: Suggestoins for Local DB to use with Shareware
- Next by thread: Re: Suggestoins for Local DB to use with Shareware
- Index(es):
Relevant Pages
|
