>>>Let me clarify. I am interested in writing a middle tier layer in VFP. The frontend will also be written in VFP. I am interested in splitting the app. in this manner to provide scalabilty so later on the backend database may be easily changed to a SQL Server , also the data may be accesible easily to other programs.
>>
>>>My question is that from the middle tier, how to return a set of records ?
>>>
>>Hi,
>>
>>I think what you want is a view of the data, whcih gives you a set of records. Write your frontend so that it talks to the view of the data. This can be a local view of VFP tables. Later you can migrate the data to SQL Server but create a view with the same name as your local view.
>>
>>Codebook frameworks allow developers to switch from local to remote views quite easily.
>>
>>Good luck,
>>
>>Paul de Niverville
>
>
>Views aren't designed for physically different tiers. They are a one or two tier solution. ADO or XML is the way to go.

Hi! I'm taking the liberty to join in here. Could you point me to some good resources on ADO there some to be a lot of discussion on it recently.

Thanks

Sonali