BorlandTalk.com

Paul Sjoerdsma · Guest

Hi,

We are developing a 3-tier app (SQLServer 2000, Midas, COM+). Our
application can be completely configured by the client or our
consultants. They can create new screens and underlying tables on the
fly. All this information is stored in a meta data area. We now want to
move from 2-tier to 3-tier using a stateless server.

The way I've normally worked with Midas 3-tier is to create a Remote
Datamodule that contains one or more Providers hooked up to stored procs
and queries. This worked fine.
However in the app described above we can't create ficed RDM's since we
don't know what tables the user has. We would like to use Midas since it
already contains, at least the ClientDataSet part, the logic to store
changes in the delta property.
What would be the best way forward?

One option would be:
When the user opens a screen, issue an appropriate request to the middle
tier and stream the relevant data from the middle tier to the client
side CDS. When the user makes changes use the changes in the Delta
property to send these changes back to middle tier. In this case could I
use all the update logic of the CDS or do I need to catch the necessary
events and handle this myself?

Another could be:
When the user opens a screen, create an appropriate RDM with a Query and
a Provider. Set the SQL and all the other necessary stuff, but how do I
connect the client CDS to this provider?? Would this approach work?

Any ideas, suggestions, or links to appropriate examples are
appreaciated.

regards
Paul Sjoerdsma