>I have experimented with using SQL Passthrough however by doing so I must >write all of the INSERT,UPDATE, and DELETE statements in SQL rather than the >native fox. Plus I cannot use parameterized views to return just the records >that I need. I have to code each of these in SQL Passthrough.
Once you pull a View locally in FoxPro you can use CursorSetProp() to set the tables and fields you wan tto update. Then do your changes in FoxPro and issue a tableupdate(). SQL Passthrough can be parameterized like any predefined view.
>
>The third thing that I have noticed is that the Oracle connection is only open when the views are in use. With SQL Passthrough the connection remains open until a sqldisconnect is executed.
>
I don't see this as a problem. When you are done with a connection, close it.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California