When inserting records using stored procedures why are the methods in the classes always defined as functions that return a boolean?
Is this because SQL will pass back a true or false depending on whether the stored procedure executed?

Yes. Since the Application is distributed across several layers, you have to have some way for a call from one layer to a lower layer, to know whether the call succeeded/failed. Hence the functions are coded to return Booleans. hth.

The design was to keep the logic simple. When you execute a function to insert a record from your Windows form, you can use the execute statement in an If...Then block. Actually, the ExecuteNonQuery method will return the number of rows affected by the insert statement thus inserting a single record will return a 1 and not inserting a record will return a 0. Remember that a Boolean value contains a value of 0 for False and any other number other than 0 for True, which is usually 1. This makes the function return a 0 when False and any number other than 0 will correlate to a value of True.

Thearon