>Hi,
> As what I have read, middle layer in 3-tier model is used for data hadling such as data validation, retrieve and write data, and anything related to data. I have some question :
>
>1. Since COM model is used, we couldn't use dataenvironment. Are we going to use USE command to open table? According to MSDN documentaion, it IS slower than compare with open table in DATAENVIROMENT. Is it right? How to solve it?

Three-tier will be slower than the one-tier applications we normally develop in VFP. There's no way around it.

>
>2. How to return more than one record (recordset or cursor) to UI layer?

You'll need to use something like ADO.

>
>Thank you