Victor, thanks for your input. I am converting an application from from Fox 2.5 to VFP 6 to VFP/Oracle - 3 phases. I have completed phase 1 and am now working on the Oracle back-end. In this application, I am using a combination of SPT and views - views are much easier to work with when updating multiple records and the performance is adequate in most cases - and I use SPT where it isn't. What I would like to do is be able to send different parameters to the view instead of creating many different views for each parameter. This should be possible through the Parameter List property, if I can ever get it to work! If not I am stuck using create view and setting all the properties each time I want to change a parameter.

Sebastian