>martin,
>I want as much as posible port my code to SQL Server store proc and function because it allows my app to be immune to changes even we will change client app. Currently im using VFP + SQL Server and i am anticipating to upgrade it to c# soon . So for me worry less on my migration from VFP+C# i put my business Rule and object at Store Proc.I know this is not a good idea since 3tier and NTier approach would be better. but i dont have much time to do bussines objects for 3tier.
>I hope dont mind, nice haircut.Davao is still a nice place stay and you can really feel the heat of the summer here.(not the heat of smoke)

>Best regards
>Simplicio

Simplicio,

Normally it would be better to make use of the business tier. But if you are running low on time and not to mention that you are comming from VFP, I guess your goal to put the business rules on the SQL server would be valid. However, do take note that it may not apply to all. As you might be putting unnecessary tasks on the server. You can still make use of client side functions and just upgrade this function to C# later. Which I think would be better in your case.

Ever since I got back to manila I started wearing my hair differently. At least now I do not have to worry much about shampoo and heat stroke!

One thing that I really miss about our life in Davao is that, when ever we get board of doing nothing... we could always go to the beach. Even stay overnight sometimes. The nature tours were quite refreshing!

Hopefully someday we will be able to move back there... or possibly find a place just like Davao!

Best regards,

Martin