David,

I don't give end user a browse window.
I am simply building a grid with the browse command

I am also using Parametrized view, simply on purpose I want to take the best solution. Using views you are not able to take a subset of 10000 on a 100000 table in .001 sec !( with rushmore you can )

I know there is no need to use SQL backend with Views ( VFP is wonderfull with Views, that's ok ), but I am sure the VFP is able to optimize the GRID object so why they don't ?


Marcel

>Marcel,
>
>I never give the end users a BROWSE window, I use it quite a bit while coding though.
>
>Parameterized local views with grids work wonderfully with VFP data and without the need to go all the way to some SQL backend database.
>
>>BROWSE is a rushmore optimized command GRID not.
>>
>>But note that the Browse command with NAME give you a object reference
>>This object as the same methods & properties than a GRID . !!!
>>
>>Just a small difference with Before RowColl ..
>>
>>I am using BROWSE in Object Form rather than grids on large tables with filter.
>>It's running very fast !
>>
>>NO RUSHMORE GRID is just a reason to use promoted technologies. ( Like SQL Back END ! )