>Hi All!
>
>I would like to discuss about 3-tier model and about the best way to do
>this in VFP. I read the article on MS site about this, but think that
>making new OLE server every time for each new project not so good apporoach
>to RAD. Any thoughts and ideas are welcome ;)
>Personally, I think about creating my own class Tableobj that should have
>methods for read/write values in the field in general sense. Recently I
>found that the table buffering is a real trap for programmer and start this
>research to find the best way..
>
>Have a happy day
>Vladimir Shevchenko
My generic approach is to write (manually from scratch, I have to admit) one custom method for each form/class. I used to call it Fillcontrols. This method usually called from navigation routine and fills controls value/caption properties with appropriate field values. When time is ready to save a record, my code (used to be a plain cmdSave.click event) validates control Value properties (I don't have variables, and generally don't use ControlSources) and INSERT Into ... Values(...value,...value..) or Replace ... With ...value.
Edward Pikman
Independent Consultant