>>
>>I mean 'parameterized view', i.e. you will retrieve different recordsets using the same view with changeable parameter(s). Please, note that this is straightforward way, i.e. it will always work but not with the best performance. The performance issues may arise if you work with higher-volume data (let say more than 100K records).
>
>I have built now a parameterized view, and it is working fine (I have only 15K records, so no performance problems). I have still some problems with committing changes which are made in the grid. Do I have to make Tableupdate in the view and in the underlying tables? It is a single User application, so I would like to commit changes directly when entered.
Normally, you would have buffered view and non-buffered table(s), so Tableupdate will be applied to view only.
Edward Pikman
Independent Consultant