Re: Opinions needed about the best "Middleware suite" kbmMW vs. RO\DA

From: Alessandro Federici (nomore_at_spam.forme)
Date: 11/17/03

Date: Mon, 17 Nov 2003 11:18:24 -0600

"Sol Brown" <> wrote in message

> 1. Cross-db option that both offer, so which framework is better suited
> this?.

Data Abstract articles can be found at:

Those that answers this question best are "DA03 - Introduction to Schemas"
and "DA08 - DA08 - No-Code n-Tier Applications with Data Abstract ".

Pay close attention to the macro processors (see the big "tip" towards the
end in DA08) and the fact you could also work having two databases that are
different in structure (DA03). We have a demo working against MSSQL
Northwind and Interbase Employee.gdb

> 2. I'm trying to figure out if those framework would give any boost to
> performance for say an enviroment of about 20-30 users, since my app is
> already using Chached Updates. (I guess the answer for that would be "just
> try it yourself", but its hard for me, since those users are not in my
> personal network, they are just clients using my app)

That probabily depends on on how you code your application and what database
you use more than anything else.
I need more information to answer this question more precisely.

> 3. I'm making heavy use of identity fields of sql server, they serve as my
> primary field, would they get refreshed when record gets posted to the
> server?.

We have samples that show how that can be done in two ways.

> 4[..] I would like to
> know if there is an official implementation for this, as well as
> updates" like, and cascading delete, so if you delete a master
> record it deletes all detail records, and of course when you apply the
> updates to the database, it deletes first the detail records then the
> ones?

I am not sure why you wouldn't want to have the posted in one transaction,
but regardless you have control of that if you want it. Our data tables have
properties that allow you to control how cascade deletes and updates work.
You can have all the details deleted automatically if your master is delete
(no code, just set a property) and you can decide to send deltas in one
delta or using individual deltas whenever you decide it's time. It's very
similar to the ADO.Net dataset.

> 5. How do they work with calculated?. well, one of the main purposes of
> n-tier is (noted on kbmMW's site) is that you have all your bussiness
> on the middle tier, so it could be used with diffrent types of clients.
> does this apply to calculated fields, that should be calculated on client.

We have client side and server side calculated fields.

> 6. What about if you have diffrent sql for insert/update/delete/refresh,
> which I make heavy use of in sdac?, are you able to use (if you want) and
> default sql, where the it autamaticly creates the sql (for
> update/delete/refresh) at run-time, and of course when you want to put
> own sql you could. Or for each update/delete you have to enter in

You have *total* control on this. Refer again to the schema article.
You can have SQL automatically generated or choose to use your own
statements (which can either use stored procedures or plain SQL). This was
the first goal of our schema-based architecture.

> 7. What about when you do some update to the database on a record, could
> supply some additional sql's that should run when you do database updates,
> for instance when you create an invoice, and you want to update the
> inventory table, could you do it in one sql (like a sql scripts), which is
> how how do it in sdac.

You can do that by using the events in our Business Processor component.
After you process an update OR a whole set of updates, you can then fire
additional commands to perform addidional tasks.

> 8. This is my main concern, one of my main goals of going to n-tier, is to
> have a centrilized place of placing, all business logic as well as my
> formating (attributes) of my fields, like caption, alignment, size ect.,
> well my main question is about the "formating part", how does this
happen?, [..]

Our schemas allow you to set all that information and, in top of that, you
can also use our Data Dictionary to share field attributes reused accross
many datasets. For example, imagine you have an field called PhoneNum which
should have a DisplayLabel of "Phone Number" and it is used in 20 datasets.
What you would do is create an attribute set in the Data Dictionary and then
associate that to the fields in the various Schema datasets.
Our fields also support regular expressions.

See more about this in the paragraph "Data Dictionary" in the article DA03

> Sorry for this lengthy message, but this is actually want to know, if both
> or any of those frameworks offer those stuff.
> Thank so much for you help

We support all that and a lot more.
Check the article DA04 and DA06 to see something really unique to boost your
productivity and "style".

Best regards,
  Alessandro Federici
RemObjects Software, Inc.