Kevin,

Check Class Based Data Management as Presented by Andy Kramek at Advisor Devcon 2001 at http://www.tightlinecomputers.com/Downloads.htm.

>I'v posted a few questions like this before, but I'm still gather info
>at this point, so...
>
>I have a VFP 7 app written against Fox2x tables. I'd like to rewrite in
>VFP 8. This time, I'd like to set it up so that, in the not to distant
>future, I can switch to SQL Server. For now however, I'll have to stick with
>the Fox2x tables.
>
>I was considering a multi-tier approach, with the a tier that gathers
>data and presents it to the GUI layer.
>
>I am sure the structure of the data will change when the transition to
>SQL is made, and I'd prefere to not have to go back into the GUI and rewrite.
>So any data passed to the GUI would have to confirm to a structure the GUI
>would already be set up to use.
>
>I have been considering using COM objects and either passing the data
>as XML or ADO.
>
>I'm open to any suggestions.