>>>I use parameterized views and SPT via ODBC. Since my data retrieval is limited to what the user needs at the time, I see no performance problems. Usually I have a mix of Oracle and VFP tables.
>>So all your front end development in in VFP? It just seems that oracle's developer2000 end product(have you seen it) lags far behind.
Mark, I am still trying to piece things together with my view. If I simply do a browse, it takes 10 mins to gather/display all 5000 records. then you mentioned parameterized views. Is this something that's built into the view or done in a program?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."