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

From: Luke Miller (lmiller_at_rescorsoft.com)
Date: 11/18/03 

Date: Tue, 18 Nov 2003 12:02:53 -0500

Slightly off-topic but it would be great if we could get those
articles/whitepapers as PDF's. Just a suggestion.

Luke
"Alessandro Federici" <nomore@spam.forme> wrote in message
news:3fb902d8$1@newsgroups.borland.com...
> "Sol Brown" <test@msn.com> wrote in message
> news:3fb8fa0d$1@newsgroups.borland.com...
> [..]
>
> > 1. Cross-db option that both offer, so which framework is better suited
> for
> > this?.
>
> Data Abstract articles can be found at:
>
>
http://www.remobjects.com/articlecategories.asp?id=D68A44BB-08A7-4817-9EE6-AE3B40994554
>
> 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
> "Cascading
> > updates" like ado.net, 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
> master
> > 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
> logic
> > on the middle tier, so it could be used with diffrent types of clients.
> how
> > 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
> your
> > own sql you could. Or for each update/delete you have to enter in
> manually?.
>
> 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
> you
> > 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.
> http://www.remobjects.com
>
>
>
>

Relevant Pages

  • Re: Access vs SQL
    ... > to SQL. ... Are you using the database primarily as a storage place, ... If you have many updates then you need to constantly compact it. ... No additional cost to your clients. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: running shell scripts from Filemaker Pro SERVER
    ... upgrade the clients is helpful at least, but that, i agree, is pretty ... and that person runs the script manually. ... logged in a utility table in the database. ... eventually the machine that actually does the updates will process it. ...
    (comp.databases.filemaker)
  • Re: slow logon
    ... in the logon time have been reduced so far. ... update the time for the clients that talk to the dc as the logon server. ... start up script in AD to apply updates to the clients machines which is ...
    (microsoft.public.windows.server.active_directory)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Clients not updating with WSUS 3.0
    ... I was talking about the one you see on the taskbar on the client, which indicates that there are updates waiting to be installed. ... The one you see next to an update within WSUS, is an indicator that the update has to be 'approved' before it will be rolled out. ... Right click on the update and approved it and then it will be scheduled to be pushed out to the clients. ... sitting at the server, in Update Services console, looking at the computers. ...
    (microsoft.public.windows.server.sbs)
Loading