>>>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?
OK, I thought I was just missing something.
>Granted, SQL Server is the place to do TOP NN vs VFP.
Agreed.
>While I got you on the line.
>
>My old shop has a custom pricing mode. I'll continue in private mode.
>
OK