Anthony,
>I like this approach. But what I'm not sure of, is when I get down to the GetSQLString method, if my parameter values are stored in business object properties, I need to reference them in the GetSQLString as :
>
> this.parent.oparentobj.propertyname
>
>Is this the best way?
Actually, the parameters and their values are passed to the data access object's Requery method in the taParms parameter which in turn passes them to the GetSQLString method, so you can simply pick them up from there.
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