Is there some where I can find a basic subclass of the BO that has Everything that is needed to make it work so I can start adding some of these functions and not have to do it on Every BO?

Hi Terry,

Yes, there are some sample code in the forums, probably Ivan (the Google expert) may provide some links, but basically this what you have to do:

1. Create a BO class and do not map it to any of your tables.  You could name it whatever you want, I name mine "ApplicationBaseBusinessClass.vb"
2. Add all the custom, generic code you expect to use in all your BOs like the ones I posted here.  Also if you use some custom field properties in all your BO with the same name, here is a good place to have them all.
3. In your current and new BO, change the "Inherits" statement from:

     Inherits MicroFour.StrataFrame.Business.BusinessLayer
to
     Inherits CardTrackingSystem.Business.ApplicationBaseBusinessClass

Of course in the sample above the namespace "CardTrackingSystem" should be replace with your own NameSpace.  After that, recompile your project and start having fun with your base BO class.

Edhy Rijo

So let me get this straight. 

Yeap you are now in the right track, so go for it.  Also for your current BO all you need to do is change the Inherits to your new base BO, the same thing applies to forms and other controls.

Edhy Rijo

Hi Edhy.

This might sound like a silly question but I 'Asumed' that a primary key field in SQL 'had' to be unique and you could not have duplicates ?. This must'nt be the case if you have written a routine to validate it ?? 

Hi Gerard,

Nothing silly about it.  Even thought you may come across an Integer PK which is not auto incremented by the database, but you are right.  That was a code I wrote fast without testing for Terry, but was corrected in the following messages.

Edhy Rijo