On the other hand, we are evaluating using Strataframe for the front end to ease into your world.
The question is, how should the application be layered to take advantage of Strataframe facilities yet place the majority of the calculations in a VFP component? As user enters data and calculations are performed by the VFP layer, how would the data be shared between the layers?
TIA,
Alex
As data is entered in this application a lot of recalculations are made to provide feedback of overall results up to that point. The recalculations include consulting this and previous transactions and use SQL SELECT commands intensively. Since data will be stored accross the internet recalculations should be made in the server with only results sent back. I am told that with OleDB the stored procedure would run at the client.
A solution might be to use a com object running at the server and accessed via SOAP. Although not totally clear how to accomplish that, I believe that process would run at the server. It also would solve the problem of keeping intermediate results between calls. BTW, in this app there wouldn't be many simultaneous clients, so there isn't a resources problem.
Does this approach sound like something that can be done with Strataframe?
Thank you. Alex
This is a perfect place to use the Enterprise Server. It will reside on the server and execute your queries or sprocs locally. You can use COM, but this becomes much more cumbersome and not as efficient.
Unfortunately Enterprise Server is too much and too expensive for this situation. We hope to eventually have dozens of installations each with its data but only one to three users. If later that is extended to providing centralized data for many clients, it would be another story.
How would the COM approach work?
Thanks, Alex
If you are going to have the need for clients to talk to a remote database, then you will have to use some type of remote approach such as Remoting, Serialization, Sockets, VPN....something before you even get to the COM class. At that point creating the COM is the simple part. You just have to create a class library that is COM Visible and expose the logic that will be used to talk to the databases via business objects.
Thanks, I'll look into that.