>I agree that I will need to move my app to VFP8. And I agree that is seems that XML is a good way to move data between UI and BIZ tiers. But ..<g>
>
>My problem is that I am concerned how this change will effect the UI tier (which what customers see). You see, my UI forms allow customer to view the entire table (even if it has 200,000 records). That is the form has navigational buttons <1st,Prev,Next,Last> and a grid where it is easy to move to any record with just a click. If I separate the UI from the tables, the UI will have to make a lot of trips to data/biz tier to get data as the customer wants to see different records. Performance will probably suffer. And I don't even know what to do with the grid. So a lot to think about.

Hmmm, there is a problem there and it would be "ideal" if you could have some sort of filter/search facility so you can display only the records that match.

There may also be the possibility of having the cursor increasing its size on demand, display the first 100 records, if they scroll further down the list, bring the next 100 and so on. If that's not feasible then display the first 100 records and gather the remaining records in the background, by the time they've scrolled down through the first 100 or so, the majority would've already been loaded.

Or is that not the way it works?

Kev