Kevin,

>You'll have to use ADO.NET to do a SELECT * statement and bind the data to the grid.

>In any distributed environment, a SELECT "where condition" (or invoking a stored proc with parameters) and then binding to the result should be done, REGARDLESS of the tool. I don't think I've ever heard a valid reason for binding a grid directly to a table with 1 million record - that is nonscalable.

Exactly. Indeed in a distributed environment. However as you know, not all VFP applications do use this strategy. There are a lot of pop and mom applications, or standard solution that don't have a 'distributed' environment. Hence my comments: you can't just USE a table and bind it to a grid.

Whether you'd should do this in VFP or not is a different discussion IMO, but both you and I know there are a lot of VFP application doing exactly this.

>...VFP this is much less an issue.

>That's really only true in a desktop, local area network environment...again, that approach won't scale.

True. But again this was not the discussion. Personally I'd get the impression that scalability is a bit over-used argument. Of course for large projects with lots of clients in a growing and complex environment (enteprise) this is the most reccomendable strategy. But again for a lot of (pop and mom) applications scalability is a non - issue.

Walter,