Milt,

>I have purchased Jim Booth book on FoxPro and want to use local views in my application. The application is not client server I am using FoxPro tables. Is there any performance benefit to using view versus set filter. Thanks

It depends..

If you're going to adress only a fraction of the table then use views. Local views are ideal for small resultsets because it makes navigation trough the resultset faster.

If you're going to adress large portions of the table(s), then use filters because the local views will take significant amounts of time to execute. Also if the filter's selectivity is low (a low percentage of the table is filtered out), you'll have no performance problems with navigation, plus the advantage of being able to use the original indexes of the table.

Walter,