Hiya Steve,

If the application is pure VFP to Oracle, there is no real advantage in creating an out-of-process server (DLL) in VFP. You're better served by creating a wrapper class for database calls and/or business rules and linking that class into your project file to create a virtual 3-tier solution. This will also make the application run a bit faster.

Now, a reason you may want to wrapper database calls and business rules is the possibility down the road that you may wish to scale up to true 3-tier (say if a VB app talks to the same Oracle data) and it'll be much easier to do that if you've coded using a virtual 3-tier framework.


>Now that we are finally moving this app to talk to VFP and Oracle databases, we are wondering if there is any advantage to using a VFP DLL as middleware to handle the SQL calls and returning the cursors or whether we should just create them as classes inside of the app.
>