Rex,
>I'm actually looking for advice on where I would put the replace for the price field in my example. If I just put it
>in the Valid or LostFocus, doesn't this violate the 3 tier model?
Issuing the REPLACE in the valid of your text box works great in a desktop application...even in an n-tier architecture. However, if you want to take it one step further and make it work in both a desktop and Internet application, you can add a "SetPrice()" method to the business object that accepts the price as a parameter and issues the REPLACE internally. This method can then be easily called from both a VFP UI as well as a Web app.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com