I have an app that currently uses Fox2x tables. I want to redesign
the app in 2 stages.

First, I want to rebuild it in VFP, using the same tables. Next,
I want to convert the app to SQL Server.

I'd like to create a data layer that I can just swap out when the
time is right, but I'd like to minimize the amout of changes that
would be needed in the forms and other areas.

The data layer would simple return the requested recordset, either in
the form of a SQL command in VFO against native foxpro tables into a
cursor, and then later against views and/or updatable recordsets.

So, in practice, a form could call a procedure to get the desired recordset
from the data layer. But what format do I return it in that would work with
both forms of database?

I'd really like to code the forms once and only have to deal with the data
layer.

Thanks