>>DBSetProp('SUMVIEW', 'View', 'FetchSize', 20)
>>
>>__Stephen
>
>Stephen,
>
>How does this affect the number of records returned? Isn't FetchSize just a count of how many will be returned at one time? You'll still get all the records, eventually, right?


Yes, and in a side note, that is what he is doing. He looks at the top 20, the next 20, and so on.

Why not bring them all back, and view them local?

Granted, SQL Server is the place to do TOP NN vs VFP.

While I got you on the line.

My old shop has a custom pricing mode. I'll continue in private mode.

__Stephen