> -----Original Message-----
> What is the perceived wisdom about where to put business rules for a
> simple app? (Into the database or the front end?)

Personally, I prefer to put as much logic into the database as possible. I
also make heavy use of stored procedures, even for selecting records. This
makes it easier in the long run to change the behaviour or add functionality
without having to make too many chanes to the UI.

> I'm planning a commercial Win32 (Firebird) database application which
> will mainly be used as a single user standalone program, with a small
> percentage of users using a networked workgroup version, so this is
> unlikely to ever need 3 tier architecture.

Although n-Tier apps take slightly longer to code, there is, IMO, a clear
benefit to having a business layer, especially when it comes to maintenance
and bug fixing.

rgds

Si Carter
http://www.fbtalk.net/
http://sourceforge.net/projects/fbutils/
http://sourceforge.net/projects/dnfbb/