>Moises,
>
>You should only use filtered tables and grids if you have very small number of records total on the order of a couple of hundred rows. Beyond that the performance of the grid will truly suffer. You will also have to deal with the vertical scroll thumb will not go all the way to the top or be sized relative to the number of rows. Parameterized views do not suffer these problems.
>
>>I have a table with a field called week_day
>> In a form I have a grid and a cursor
>>
>> Is the syntax below correct ?
>>
>> set filter to "week_day = 'monday'"
>>
>> It's supposed to show a grid with only records containing
>> monday.
>>
>>
>> Also
>>
>> How can I cancel the filter so that all
>>records are showed in the grid



are you saying that if i am outputting a report from a table
with (say) 358 thousand records, that performance will be better if i
base the report on a parameterized view of that table as opposed to setting
a filter on the table and using the table itself ?