>I too am using VFP to put a front end onto an Oracle App, and have found the best way to deal with Oracle views, or views on an Oracle table is to create the views in Oracle ( I cheat and use Visual C++ database designer to build the views, it's WISIWYG). I use the Oracle Client driver (8.0.5) for the connection and have only minor problems(see my post in forms) passing SQL. Note, it is PL/SQL, not the other way around.

I agree with you 100%! Using a view in Oracle before pulling them into VFP is the way to go. The original problem that started this thread a few days ago was from a developer who did not have access to the Oracle database and couldn't create any views in Oracle. He was stuck. I've found VFP to be a great front end for Oracle. It's nice to see more postings here about VFP/Oracle.

Gregg