Re: Conversion from BDE to ADO

From: Betsy (betsy.a.tainer_at_lesschwab.com)
Date: 03/30/04

  • Next message: Bill N: "TADOStoredProc.Recordset.Fields[i] and TField" 
    Date: Tue, 30 Mar 2004 10:57:50 -0800

    John... I am in the process of updating company pc applications build in D5
    w/ Paradox.. update includes D7 w/ MSSQL... performance is HUGELY improved.
    It's been a challenge to get a firm grip on the new ADO components... but am
    overall very happy with the end results... my new applications SCREAM!

    Mine are relatively small apps with small groups of users... have not
    noticed any problems in the way of record locking.... doesn't mean they are
    not there waiting to make my day.

    good luck!
    b
    "John Faris" <johnfaris@nospam.hotmail.com> wrote in message
    news:40616715$1@newsgroups.borland.com...
    > Hi all.
    >
    > I am currently experimenting with converting a quite large app from BDE to
    > ADO. It accesses a MS SQL 2000 database, and before I commit and jump
    > headlong into this I wonder if there are any major issues to be aware of?
    > One of the main benefits I am hoping for is better multi-user detection
    > capabillity e.g. if one user changes a record another has open and then
    the
    > other user tries to change they get an appropriate error message. I have
    > found BDE support for this a little flakey at best. Are there any setting
    > changes from the default on TAdoQuery or TAdoConnection that I should
    > definitely make? Finally I have seen a fair bit of discussion around
    > suggesting that ADO will slow my app down, is this true?
    >
    > Many thanks for any input.
    >
    > John.
    >
    >

  • Next message: Bill N: "TADOStoredProc.Recordset.Fields[i] and TField"

    Relevant Pages

    • Re: PC Astronomy Software Running On Macs
      ... But recall that you also stated you were not interested in Mac native ... applications, many of which do what your favorite PC programs do. ... Maxim is arguably the best camera control and guiding app ... of my message will satisfy John, and warrant a more reasonable reply. ...
      (sci.astro.amateur)
    • Re: What happened? Non of VB code works
      ... Providing Customers A Resource For Help With Access, Excel And Word ... Applications ...
      (comp.databases.ms-access)
    • Re: Work Menu - Word:mac 2008
      ... Then the software industry split them into four different applications so ... With a .plist to tell it how to display itself. ... Not sure whether you're addressing John or me, ... McGhie Information Engineering Pty Ltd ...
      (microsoft.public.mac.office.word)
    • Re: Struts workflow
      ... John wrote: ... It also has a complete app with database calls. ... I will recommend another book, ... It's "Programming Jakarta Struts" by Chuck Cavaness, ...
      (comp.lang.java.programmer)
    • Re: Static class in an asp.net application.
      ... does it start a new AppDomain. ... > specially when comming from win32 client applications. ... What documentation did you look at when getting started in ... John Saunders ...
      (microsoft.public.dotnet.framework.aspnet)