Ooops --- let me correct my technical terms here: DLLs are in-process while EXE are out-of-process....regardless, there still is no real advantage.
>
>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.
>>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05